F0411 GDPdU Data Extraction Program (R89F0411G)

When you run the F0411 GDPdU Data Extraction program, the system generates a text file named F0411GDPDU.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 STAM is for the tax amount. This field includes the Accuracy tag.

Fields	Description of Value
DOC	Document number
DCT	Document type.
KCO	Document company.
SFX	Document pay item number
SFXE	Pay item extension number
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.
DCTA	Document type – adjusting
DCTA description	Document type – adjusting value description. The extraction program calls GetUDC (X0005) for the Document Type (00/DT) UDC and writes the description to the text file.
AN8	Address number
AN8 description	Address number value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
PYE	Address number – payee
PYE description	Address number – payee value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
DIVJ	Date – invoice
DSVJ	Date – service/tax
DGJ	Date – G/L
FY	Fiscal year
CTRY	Century
PN	Period number
CO	Company
CO description	Company description The extraction program calls GetCompanyName (B0000051) and writes the description to the text file.
PST	Pay status code
PST description	Pay status code value description. The extraction program calls GetUDC (X0005) for the Payment Status (00/PS) UDC and writes the description to the text file.
AG	Amount – gross
AAP	Amount – open
ATXA	Amount – taxable
ATXN	Amount – non-taxable
STAM	Amount – tax
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.
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
ACR	Amount – foreign
FAP	Amount – foreign open
CTXA	Amount – foreign taxable
CTXN	Amount – non-foreign taxable.
CTAM	Amount – foreign tax.
GLBA	G/L bank account.
GLBA description	G/L bank account value description. The extraction program calls RetrieveAccountMasterInfoGLPost (B0900104) and writes the description to the text file.
POST	G/L posted code.
VOD	Void flag.
VINV	Supplier invoice number.
RMK	Name – remark.
PYIN	Payment instrument.
PYIN description	Payment instrument value description. The extraction program calls GetUDC (X0005) for the Payment Instrument (00/PY) UDC and writes the description to the text file.
TXA3	Tax rate/area 3 – withholding.
TXA3 description	Tax rate/area 3 – withholding value description. The extraction program calls EditTaxRateArea (B0000140) and writes the description to the text file.
EXR3	Tax explanation 3 – withholding.
EXR3 description	Tax explanation 3 – withholding value description. The extraction program calls GetUDC (X0005) for the Tax Explanation Code (00/EX) UDC and writes the description to the text file.
AC07	Category code – address book 07.
AC07 description	Category code – address book 07 value description. The extraction program calls GetUDC (X0005) for the Address Book Category Code 07 (01/07) UDC and writes the description to the text file.
TNN	Flag for 1099.
DTXS	Deferred tax status – VAT.
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.
ATAD	Amount – to distribute.
CTAD	Amount – foreign to distribute.
NRTA	Amount – nonrecoverable tax.
FNRT	Amount – foreign nonrecoverable tax.
TAXP	Purchasing taxable Y/N.