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.
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. |