Skip to Content

Extract Customer Field Status Group

Hi Experts,

I'm trying to extract Customer field status group into Excel.

In the table T077D, I get values like "+.+..+.....--+..........+.....+........." which I know what each symbol represents. However, the order of the field does not seem to tally.

For example:

In T077D-FAUSA (General Data) = +.+..+.....--+..........+.....+.........
There are only 40 characters here, which means it is only up to "Nickname" field.
How about the remaining 59 fields in General Data?
And the 2 symbol "-" for "Transportation zone" and "Tax jurisdiction code" is supposed to be "+" and "." respectively upon checking against the configuration in OBD2.

Did anyone ever had to do what I'm doing here and how did you do it?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 20, 2017 at 12:31 PM

    Hi J Tan,

    In OBD2 enter in a Group, enter Field Status, put the cursor in Account Group , Go to Extras -> Subgroup Lists -> With Item specification .

    There you will have the field order and in table T077D fields FAUSA, FAUS1, FAUS2 (40 characters each field) will complete all fields.

    Some positions are missing (like 14, 31) , it may be for compatibility with older versions.

    Kind Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 12:10 PM

    Hi,

    Apart from FAUSA, you have additional data in FAUS1 and FAUS2.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded