F03B11 GDPdU Data Extraction Program (R89F03B11G)

When you run the F03B11 GDPdU Data Extraction program, the system generates a text file named F03B11GDPDU.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.
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.
AN8	Address number
AN8 description	Address number value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
DGJ	Date – G/L.
DIVJ	Date – invoice.
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.
PA8	Address number – parent.
PA8 description	Address number – parent value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
AN8J	Address number – alternate payee.
AN8J description	Address number – alternate payee value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
PYR	Address number – payor.
PYR description	Address number – payor value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file.
POST	G/L posted code
ISTR	A/R post status
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
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.
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.
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.
DSVJ	Date – service/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.
RSCO	Write-off reason code.
RSCO description	Write-off reason code value description. The extraction program calls GetUDC (X0005) for the Reason Code (03B/RC) UDC and writes the description to the text file.
VLDT	Date – cleared/value.
RMK	Name – remark.
ALPH	Name – alpha.
RYIN	Payment instrument.
RYIN 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.
VDGJ	Void date.
VOD	Void flag.
JCL	Date – invoice close.
DDEX	Deduction reason code.
DDEX description	Deduction reason code value description. The extraction program calls GetUDC (X0005) for the Deduction Reason Code (03B/CR) UDC and writes the description to the text file.
DTXS	Deferred tax status - VAT.
ATAD	Amount – to distribute.
CTAD	Amount – foreign to distribute.
NRTA	Amount – nonrecoverable tax.
FNRT	Amount – foreign nonrecoverable tax.
SOTF	Sales order tax flag.
ERDJ	Date – for exchange rate.
AJCL	Date – actual invoice closed.