F0911 GDPdU Data Extraction Program (R89F0911G) (Release 9.2 Update)

When you run the F0911 GDPdU Data Extraction program, the system generates a text file named F0911GDPDU.txt, and writes the file to the Export directory for your installation. The system writes data for the selected records for the data items listed in this table, in the order listed.

Note: If a field in this file is for a number, the field includes the number of decimals in an XML Accuracy element within the field's XML tag. For example, the field Amount includes the Accuracy tag.

Field	Description of Value
DCT	Document type.
DOC	Document number
KCO	Document company.
DGJ	G/L date.
JELN	Journal entry line number.
LT	Ledger type.
EXTL	Line extension code.
DCT description	Document type value description. The extraction program calls GetUDC (X0005) for 00/DT UDC and writes the description to the text file.
KCO description	Document company value description. The extraction program calls GetCompanyName (B0000051) and writes the description to the text file.
LT description	Ledger type value description. The extraction program calls IsColInLedgerTypeTable (B0000378) and writes the description to the text file.
POST	G/L posted code.
CO	Company.
CO description	Company description. The extraction program calls GetCompanyName (B0000051) and writes the description to the text file.
MCU	Business unit.
MCU description	Business unit value description. The extraction program calls IsColumnInBusinessUnitTable (ISCOLBU) and writes the description to the text file.
OBJ	Object
SUB	Subsidiary
PN	Period number
CTRY	Century
FY	Fiscal year
CRCD	Currency code – from
CRCD description	Currency code value description The extraction program calls F0013GetCurrencyDescription (B03B0103) and writes the description to the text file.
CRR	Currency conversion rate
AA	Amount
EXA	Name – alpha explanation
EXR	Name – remark explanation
AN8	Address number
AN8 description	Address number value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
CN	Payment number
ALTX	Consumption tax cross reference.
DSVJ	Date service/tax
BCRC	Currency code – base
BCRC description	Currency code – base value description. The extraction program calls F0013GetCurrencyDescription (B03B0103) and writes the description to the text file.
TXA1	Tax rate/area 1
TXA1 description	Tax rate/area 1 value description. The extraction program calls EditTaxRateArea (B0000140) and writes the description to the text file.
EXR1	Tax explanation
EXR1 description	Tax explanation value description. The extraction program calls GetUDC (X0005) for the Tax Explanation Code (00/EX) UDC and writes the description to the text file.
TXITM	Tax – short item number
TXITM description	Tax – short item number value description. The extraction program calls GetItemMasterByShortItem (X4101) and writes the description to the text file.
ACR	Amount currency