Extract Customer Field Status Group

[former_member333607]

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.

[Gustavo_Vazquez · Accepted solution]

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

[former_member333607 · Accepted solution]

Hi Gustavo,

It is making sense now. Thank you so much!

[iklovski]

Hi,

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

Regards,

Eli