F0018 GDPdU Data Extraction Program (R89F0018G)
When you run the F0018 GDPdU Data Extraction program, the system generates a text file named F0018GDPDU.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 Values |
|---|---|
DOCO |
Document number (Order No,Invoice,etc.). |
DCTO |
Document type. |
KCOO |
Order company. |
SFXO |
Document pay item number. |
LNID |
Line number. |
UPMJ |
Update date. |
UPMT |
Update time. |
DCTO Description |
Document type value description.The extraction program calls Get UDC(X0005) for 00/DT UDC (userdefinedcode) and writes the description to the text file. |
KCOO Description |
Document company value description.The extraction program calls Get Company Name(B0000051) and writes the description to the text file. |
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 |
AN8 |
Address number |
AN8 description |
Address number value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
ECST |
Amount extended cost. |
AEXP |
Amount extended price. |
ATXN |
Amount – nontaxable. |
ATXA |
Amount – taxable. |
NRTA |
Amount – nonrecoverable tax. |
STAM |
Amount – tax. |
TXA1 |
Tax 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 1. |
EXR1 description |
Tax explanation 1 value description. The extraction program calls GetUDC (X0005) for the Tax Explanation Code (00/EX) UDC and writes the description to the text file. |
EXR2 |
Tax explanation 2. |
EXR2 description |
Tax explanation 2 value description. The extraction program calls GetUDC (X0005) for the Tax Explanation Code (00/EX) UDC and writes the description to the text file. |
TRDJ |
Transaction date. |
DGL |
Date – G/L date. |
DSVJ |
Service/tax date. |
TX |
Taxable Y/N |
ITM |
Item description. |
ITM description. |
Item description value description. The extraction program calls GetItemMasterByShortItem (X4101) and writes the description to the text file. |
LITM |
Second item number. |
LITM description |
Second item number value description. The extraction program calls GetSecondItemDescription (B4100321) and writes the description to the text file. |
AITM |
Third item number. |
AITM description |
Third item number value description. The extraction program calls GetThirdItemDescription (B4100322) and writes the description to the text file. |
LNTY |
Line type. |
LNTY description |
Line type value description. The extraction program calls GetLineTypeConstants (B4000260) and writes the description to the text file. |
UORG |
Units – order/transaction quantity. |
UOM |
Unit of measure. |
UOM description |
Unit of measure value description. The extraction program calls GetUDC (X0005) for the Unit of Measure (00/UM) UDC and writes the description to the text file. |
FVTY |
Factor value – type. |
FVTY description. |
Factor value – type value description. The extraction program calls GetUDC (X0005) for H00/FV UDC and writes the description to the text file. |
TA1 |
Tax authority 1 |
TA1 description |
Tax authority 1 value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
TXR1 |
Tax rate 1. |
TA2 |
Tax authority 2 |
TA2 description |
Tax authority 2 value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
TXR2 |
Tax rate 2. |
TA3 |
Tax authority 3 |
TA3 description |
Tax authority 3 value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
TXR3 |
Tax rate 3. |
TA4 |
Tax authority 4 |
TA4 description |
Tax authority 4 value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
TXR4 |
Tax rate 4. |
TA5 |
Tax authority 5. |
TA5 description |
Tax authority 5 value description. The extraction program calls GetAddressBookDescriptionA7 (GETABDA7) and writes the description to the text file. |
TXR5 |
Tax rate 5. |
STA1 |
Tax amount 1. |
STA2 |
Tax amount 2. |
STA3 |
Tax amount 3. |
STA4 |
Tax amount 4. |
STA5 |
Tax amount 5. |
OVTX |
Tax override. |
TXVA |
Amount – tax variance. |
TXVR |
Percent – tax variance. |
POST |
G/L posted code. |
GDVL |
Amount – goods value. |
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 |
SQNO |
Sequence number. |
AG |
Amount – gross. |
APD |
Amount – paid. |
TAXE |
Amount – sales tax exempt. |
DOC |
Document number. |
PROCFL |
Tax processing flag. |
ADJFL |
Value-added tax (VAT) adjustment flag. |
TOFL |
Transaction origin flag. |