|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
PostingSaf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingSafInputSequence
|
Sequence
|
Seq
|
9
|
|
|
|
PostingSafParentType
|
Parent Type
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
LastModDate
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
PostingIdx
|
no
|
Posting_ID
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingSaf_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafStrIdx
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentre1Saf_ID
|
Link to CostCentre-SAF1
|
|
-99999999999
|
|
|
|
CostCentre2Saf_ID
|
Link to CostCentre-SAF2
|
|
-99999999999
|
|
|
|
CostCentre3Saf_ID
|
Link to CostCentre-SAF3
|
|
-99999999999
|
|
|
|
CostCentre4Saf_ID
|
Link to CostCentre-SAF4
|
|
-99999999999
|
|
|
|
CostCentre5Saf_ID
|
Link to CostCentre-SAF5
|
|
-99999999999
|
|
|
|
CostCentreSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
GL1Saf_ID
|
Link to GL-SAF1
|
|
-99999999999
|
|
|
|
GL2Saf_ID
|
Link to GL-SAF2
|
|
-99999999999
|
|
|
|
GL3Saf_ID
|
Link to GL-SAF3
|
|
-99999999999
|
|
|
|
GL4Saf_ID
|
Link to GL-SAF4
|
|
-99999999999
|
|
|
|
GL5Saf_ID
|
Link to GL-SAF5
|
|
-99999999999
|
|
|
|
GLSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PostingSafCombined_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Project1Saf_ID
|
Link to Project-SAF1
|
|
-99999999999
|
|
|
|
Project2Saf_ID
|
Link to Project-SAF2
|
|
-99999999999
|
|
|
|
Project3Saf_ID
|
Link to Project-SAF3
|
|
-99999999999
|
|
|
|
Project4Saf_ID
|
Link to Project-SAF4
|
|
-99999999999
|
|
|
|
Project5Saf_ID
|
Link to Project-SAF5
|
|
-99999999999
|
|
|
|
ProjectSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCSafStr
|
no
|
CostCentreSafStructure_ID
|
yes
|
no
|
|
|
CostC1Saf
|
no
|
CostCentre1Saf_ID
|
yes
|
no
|
|
|
CostC2Saf
|
no
|
CostCentre2Saf_ID
|
yes
|
no
|
|
|
CostC3Saf
|
no
|
CostCentre3Saf_ID
|
yes
|
no
|
|
|
CostC4Saf
|
no
|
CostCentre4Saf_ID
|
yes
|
no
|
|
|
CostC5Saf
|
no
|
CostCentre5Saf_ID
|
yes
|
no
|
|
|
GL1Saf
|
no
|
GL1Saf_ID
|
yes
|
no
|
|
|
GL2Saf
|
no
|
GL2Saf_ID
|
yes
|
no
|
|
|
GL3Saf
|
no
|
GL3Saf_ID
|
yes
|
no
|
|
|
GL4Saf
|
no
|
GL4Saf_ID
|
yes
|
no
|
|
|
GL5Saf
|
no
|
GL5Saf_ID
|
yes
|
no
|
|
|
GLSafStr
|
no
|
GLSafStructure_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingSafCombined_ID
|
yes
|
no
|
|
|
PrjSafStr
|
no
|
ProjectSafStructure_ID
|
yes
|
no
|
|
|
Proj1Saf
|
no
|
Project1Saf_ID
|
yes
|
no
|
|
|
Proj2Saf
|
no
|
Project2Saf_ID
|
yes
|
no
|
|
|
Proj3Saf
|
no
|
Project3Saf_ID
|
yes
|
no
|
|
|
Proj4Saf
|
no
|
Project4Saf_ID
|
yes
|
no
|
|
|
Proj5Saf
|
no
|
Project5Saf_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
PostingSafCombined_ID
|
Link to PostingSafCombined
|
|
-99999999999
|
|
|
|
PostingSafHist_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
PostingSafComb
|
no
|
PostingSafCombined_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingSafHist_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
PostingTemplate_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingTemplateBusRelCode
|
Business Relation
|
|
x(20)
|
|
|
|
PostingTemplateCode
|
Template Code
|
|
x(20)
|
|
|
|
PostingTemplateCostCtrCode
|
Cost Center
|
|
x(20)
|
|
|
|
PostingTemplateDateLastMod
|
Date Last Modified
|
Modified
|
99/99/9999
|
|
|
|
PostingTemplateDateLastUse
|
Date Last Used
|
Used
|
99/99/9999
|
|
|
|
PostingTemplateDivCode
|
Sub-Account
|
|
x(20)
|
|
|
|
PostingTemplateProjectCode
|
Project
|
|
x(20)
|
|
|
|
PostingTemplateTimesUsed
|
Times Used
|
Used
|
>>>9
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
PostingTemplateCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
PostingTemplate_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
FromTxzTaxZone
|
From Tax Zone
|
|
x(16)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PeriodMark_ID
|
Link to PeriodMark
|
|
-99999999999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
PostingVat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingVatBaseCreditCC
|
SC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatBaseCreditLC
|
BC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatBaseCreditTC
|
TC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatBaseDebitCC
|
SC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatBaseDebitLC
|
BC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatBaseDebitTC
|
TC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatExchangeRate
|
Exchange Rate
|
Rate
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingVatInOut
|
In/Out
|
|
x(20)
|
|
|
|
PostingVatIsAbsRet
|
Absorbed Retained
|
|
yes/no
|
|
|
|
PostingVatIsReverseCharge
|
Reverse Charge
|
|
yes/no
|
|
|
|
PostingVatIsSuspDel
|
Suspended/Delayed Tax
|
Susp/Del
|
yes/no
|
|
|
|
PostingVatOwnTaxDeclarat
|
Own Declaration Tax
|
|
->,>>>,>>9
|
|
|
|
PostingVatOwnTaxIDFeder
|
Own Federal Tax
|
|
x(40)
|
|
|
|
PostingVatOwnTaxIDMisc1
|
Own Miscellaneous Tax 1
|
Own Misc Tax 1
|
x(40)
|
|
|
|
PostingVatOwnTaxIDMisc2
|
Own Miscellaneous Tax 2
|
Own Misc Tax 1
|
x(40)
|
|
|
|
PostingVatOwnTaxIDMisc3
|
Own Miscellaneous Tax 3
|
Own Misc Tax 3
|
x(40)
|
|
|
|
PostingVatOwnTaxIDState
|
Own State Tax
|
|
x(40)
|
|
|
|
PostingVatRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingVatTaxCreditCC
|
SC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxCreditLC
|
BC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxCreditTC
|
TC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxDebitCC
|
SC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxDebitLC
|
BC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxDebitTC
|
TC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatTaxIDFeder
|
Federal Tax
|
|
x(40)
|
|
|
|
PostingVatTaxIDMisc1
|
Miscellaneous Tax 1
|
Misc Tax 1
|
x(40)
|
|
|
|
PostingVatTaxIDMisc2
|
Miscellaneous Tax 2
|
Misc Tax 2
|
x(40)
|
|
|
|
PostingVatTaxIDMisc3
|
Miscellaneous Tax 3
|
Misc Tax 3
|
x(40)
|
|
|
|
PostingVatTaxIDState
|
State Tax
|
|
x(40)
|
|
|
|
PostingVatTaxPointDate
|
Tax Point Date
|
Tax Date
|
99/99/9999
|
|
|
|
PostingVatTaxTransType
|
Tax Transaction Type
|
Tax Trans Type
|
99
|
|
|
|
PostingVatTransType
|
Transaction Type
|
Trans Type
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
ToTxzTaxZone
|
To Tax Zone
|
|
x(16)
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxenvTaxEnv
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
TxtyTaxType
|
Tax Type
|
|
x(16)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
Vat_ID
|
Tax Code
|
|
-99999999999
|
|
|
|
VatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
VatPeriod_ID
|
Link to VatPeriod
|
|
-99999999999
|
|
|
|
VatRule_ID
|
Link to VatRule
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
OwnTaxDeclarat
|
no
|
PostingVatOwnTaxDeclarat
|
yes
|
no
|
|
|
OwnTaxIDFeder
|
no
|
PostingVatOwnTaxIDFeder
|
yes
|
no
|
|
|
OwnTaxIDMisc1
|
no
|
PostingVatOwnTaxIDMisc1
|
yes
|
no
|
|
|
OwnTaxIDMisc2
|
no
|
PostingVatOwnTaxIDMisc2
|
yes
|
no
|
|
|
OwnTaxIDMisc3
|
no
|
PostingVatOwnTaxIDMisc3
|
yes
|
no
|
|
|
OwnTaxIDState
|
no
|
PostingVatOwnTaxIDState
|
yes
|
no
|
|
|
PeriodMark
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
|
PostingIdx
|
no
|
Posting_ID
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingVat_ID
|
yes
|
no
|
|
|
ReverseDate
|
no
|
PostingVatIsReverseCharge
|
yes
|
no
|
|
|
|
|
PostingVatTaxPointDate
|
yes
|
no
|
|
|
SuspDel
|
no
|
PostingVatIsSuspDel
|
yes
|
no
|
|
|
TaxPointDate
|
no
|
PostingVatTaxPointDate
|
yes
|
no
|
|
|
TaxTransType
|
no
|
PostingVatTaxTransType
|
yes
|
no
|
|
|
TransType
|
no
|
PostingVatTransType
|
yes
|
no
|
|
|
TxclTaxCls
|
no
|
TxclTaxCls
|
yes
|
no
|
|
|
TxtyTaxType
|
no
|
TxtyTaxType
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
VatGrpIdx
|
no
|
VatGroup_ID
|
yes
|
no
|
|
|
VatPeriod
|
no
|
VatPeriod_ID
|
yes
|
no
|
|
|
VatRule
|
no
|
VatRule_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
PeriodMark_ID
|
Link to PeriodMark
|
|
-99999999999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
PostingVatDelay_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingVatDelayBaseCredCC
|
SC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayBaseCredLC
|
BC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayBaseCredTC
|
TC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayBaseDebCC
|
SC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayBaseDebLC
|
BC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayBaseDebTC
|
TC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayExchRate
|
Exchange Rate
|
Rate
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingVatDelayIsOpen
|
Open
|
|
yes/no
|
|
|
|
PostingVatDelayOwnTaxDecl
|
Own Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
PostingVatDelayOwnTaxIDFed
|
Own Federal Tax ID
|
|
x(40)
|
|
|
|
PostingVatDelayOwnTaxIDM1
|
Own Misc 1 ID
|
|
x(40)
|
|
|
|
PostingVatDelayOwnTaxIDM2
|
Own Misc 2 ID
|
|
x(40)
|
|
|
|
PostingVatDelayOwnTaxIDM3
|
Own Misc 3 ID
|
|
x(40)
|
|
|
|
PostingVatDelayOwnTaxIDSt
|
Own State Tax ID
|
|
x(40)
|
|
|
|
PostingVatDelayRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingVatDelayTaxIDFeder
|
Federal Tax ID
|
|
x(40)
|
|
|
|
PostingVatDelayTaxIDMisc1
|
Misc 1
|
|
x(40)
|
|
|
|
PostingVatDelayTaxIDMisc2
|
Misc 2
|
|
x(40)
|
|
|
|
PostingVatDelayTaxIDMisc3
|
Misc 3
|
|
x(40)
|
|
|
|
PostingVatDelayTaxIDState
|
State
|
|
x(40)
|
|
|
|
PostingVatDelayTaxPntDate
|
Tax Point Date
|
|
99/99/9999
|
|
|
|
PostingVatDelayVATBalLC
|
BC Tax Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingVatDelayVATOrigLC
|
BC Tax Original
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Vat_ID
|
Description
|
|
-99999999999
|
|
|
|
VatPeriod_ID
|
Link to VatPeriod
|
|
-99999999999
|
|
|
|
VatRule_ID
|
Link to VatRule
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
IsOpen
|
no
|
PostingVatDelayIsOpen
|
yes
|
no
|
|
|
PeriodMark
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
|
PostingIdx
|
no
|
Posting_ID
|
yes
|
no
|
|
|
PostingLine
|
yes
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingVatDelay_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
VatPeriod
|
no
|
VatPeriod_ID
|
yes
|
no
|
|
|
VatRule
|
no
|
VatRule_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
Link to Currency Code
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PeriodMark_ID
|
Link to PeriodMark
|
|
-99999999999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
PostingWHT_ID
|
Record ID
|
|
-99999999999
|
|
|
|
PostingWHTBaseCreditCC
|
SC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTBaseCreditLC
|
BC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTBaseCreditTC
|
TC Base Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTBaseDebitCC
|
SC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTBaseDebitLC
|
BC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTBaseDebitTC
|
TC Base Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTExchangeRate
|
Exchange Rate
|
Rate
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingWHTFromTxzTaxZone
|
From Tax Zone
|
|
x(16)
|
|
|
|
PostingWHTInOut
|
In/Out
|
|
x(20)
|
|
|
|
PostingWHTOwnTaxDeclarat
|
Own Declaration Tax
|
|
->,>>>,>>9
|
|
|
|
PostingWHTOwnTaxIDFeder
|
Own Federal Tax
|
|
x(40)
|
|
|
|
PostingWHTOwnTaxIDMisc1
|
Own Miscellaneous Tax 1
|
Own Misc Tax 1
|
x(40)
|
|
|
|
PostingWHTOwnTaxIDMisc2
|
Own Miscellaneous Tax 2
|
Own Misc Tax 1
|
x(40)
|
|
|
|
PostingWHTOwnTaxIDMisc3
|
Own Miscellaneous Tax 3
|
Own Misc Tax 3
|
x(40)
|
|
|
|
PostingWHTOwnTaxIDState
|
Own State Tax
|
|
x(40)
|
|
|
|
PostingWHTRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
PostingWHTTaxCreditCC
|
SC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxCreditLC
|
BC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxCreditTC
|
TC Tax Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxDebitCC
|
SC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxDebitLC
|
BC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxDebitTC
|
TC Tax Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
PostingWHTTaxIDFeder
|
Federal Tax
|
|
x(40)
|
|
|
|
PostingWHTTaxIDMisc1
|
Miscellaneous Tax 1
|
Misc Tax 1
|
x(40)
|
|
|
|
PostingWHTTaxIDMisc2
|
Miscellaneous Tax 2
|
Misc Tax 2
|
x(40)
|
|
|
|
PostingWHTTaxIDMisc3
|
Miscellaneous Tax 3
|
Misc Tax 3
|
x(40)
|
|
|
|
PostingWHTTaxIDState
|
State Tax
|
|
x(40)
|
|
|
|
PostingWHTTaxPointDate
|
Tax Point Date
|
Tax Date
|
99/99/9999
|
|
|
|
PostingWHTTaxTransType
|
Tax Transaction Type
|
Tax Trans Type
|
99
|
|
|
|
PostingWHTToTxzTaxZone
|
To Tax Zone
|
|
x(16)
|
|
|
|
PostingWHTTransType
|
Transaction Type
|
Trans Type
|
x(20)
|
|
|
|
PostingWHTTxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
PostingWHTTxenvTaxEnv
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
PostingWHTTxtyTaxType
|
Tax Type
|
|
x(16)
|
|
|
|
PostingWHTTxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Vat_ID
|
Link to Tax Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
OwnTaxDeclarat
|
no
|
PostingWHTOwnTaxDeclarat
|
yes
|
no
|
|
|
OwnTaxIDFeder
|
no
|
PostingWHTOwnTaxIDFeder
|
yes
|
no
|
|
|
OwnTaxIDMisc1
|
no
|
PostingWHTOwnTaxIDMisc1
|
yes
|
no
|
|
|
OwnTaxIDMisc2
|
no
|
PostingWHTOwnTaxIDMisc2
|
yes
|
no
|
|
|
OwnTaxIDMisc3
|
no
|
PostingWHTOwnTaxIDMisc3
|
yes
|
no
|
|
|
OwnTaxIDState
|
no
|
PostingWHTOwnTaxIDState
|
yes
|
no
|
|
|
PeriodMark
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
|
PostingIdx
|
no
|
Posting_ID
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
PostingWHT_ID
|
yes
|
no
|
|
|
TaxPointDate
|
no
|
PostingWHTTaxPointDate
|
yes
|
no
|
|
|
TaxTransType
|
no
|
PostingWHTTaxTransType
|
yes
|
no
|
|
|
TransType
|
no
|
PostingWHTTransType
|
yes
|
no
|
|
|
TxclTaxCls
|
no
|
PostingWHTTxclTaxCls
|
yes
|
no
|
|
|
TxtyTaxType
|
no
|
PostingWHTTxtyTaxType
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pould_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pould__qadc01
|
|
|
x(24)
|
|
|
|
pould__qadc02
|
|
|
x(24)
|
|
|
|
pould_domain
|
Domain
|
|
x(8)
|
|
|
|
pould_loc
|
Location
|
|
x(8)
|
|
|
|
pould_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
pould_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
pould_poul_ref_key
|
Ref ID
|
|
>>>>>>>>9
|
|
|
|
pould_preference
|
Preference
|
|
>>>>>>>>9
|
|
|
|
pould_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
pould_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pould_det
|
yes
|
oid_pould_det
|
yes
|
no
|
|
|
pould_preference
|
no
|
pould_domain
|
yes
|
no
|
|
|
|
|
pould_poul_ref_key
|
yes
|
no
|
|
|
|
|
pould_preference
|
yes
|
no
|
|
|
|
|
pould_loc
|
yes
|
no
|
|
∗
|
pould_ref_loc
|
yes
|
pould_domain
|
yes
|
no
|
|
|
|
|
pould_poul_ref_key
|
yes
|
no
|
|
|
|
|
pould_loc
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_poul_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
poul__qadc01
|
|
|
x(24)
|
|
|
|
poul__qadc02
|
|
|
x(24)
|
|
|
|
poul_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
poul_domain
|
Domain
|
|
x(8)
|
|
|
|
poul_mch
|
Machine
|
|
x(8)
|
|
|
|
poul_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
poul_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
poul_pou_code
|
Point of Use Code
|
|
x(18)
|
|
|
|
poul_ref_key
|
Ref ID
|
|
>>>>>>>>9
|
|
|
|
poul_site
|
Site
|
|
x(8)
|
|
|
|
poul_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
poul_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
poul_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_poul_mstr
|
yes
|
oid_poul_mstr
|
yes
|
no
|
|
∗
|
poul_mstr
|
yes
|
poul_domain
|
yes
|
no
|
|
|
|
|
poul_pou_code
|
yes
|
no
|
|
|
|
|
poul_site
|
yes
|
no
|
|
|
|
|
poul_wkctr
|
yes
|
no
|
|
|
|
|
poul_mch
|
yes
|
no
|
|
|
poul_ref_key
|
no
|
poul_domain
|
yes
|
no
|
|
|
|
|
poul_ref_key
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_po_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
po__chr01
|
|
|
x(8)
|
|
|
|
po__chr02
|
|
|
x(8)
|
|
|
|
po__chr03
|
|
|
x(8)
|
|
|
|
po__chr04
|
|
|
x(8)
|
|
|
|
po__chr05
|
|
|
x(8)
|
|
|
|
po__chr06
|
|
|
x(8)
|
|
|
|
po__chr07
|
|
|
x(8)
|
|
|
|
po__chr08
|
|
|
x(8)
|
|
|
|
po__chr09
|
|
|
x(8)
|
|
|
|
po__chr10
|
|
|
x(8)
|
|
|
|
po__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
po__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
po__dte01
|
|
|
99/99/99
|
|
|
|
po__dte02
|
|
|
99/99/99
|
|
|
|
po__log01
|
|
|
yes/no
|
|
|
|
po__qad02
|
|
|
>>9
|
|
|
|
po__qad03
|
|
|
99:99:99
|
|
|
|
po__qad04
|
|
|
yes/no
|
|
|
|
po__qad05
|
|
|
->>9.99%
|
10
|
|
|
po__qad06
|
|
|
yes/no
|
|
|
|
po__qad07
|
|
|
x(8)
|
|
|
|
po__qad08
|
|
|
x(4)
|
|
|
|
po__qad09
|
|
|
->>,>>>,>>9.99
|
10
|
|
|
po__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
po__qadc03
|
|
|
x(24)
|
|
|
|
po__qadd01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
po__qadd02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
po__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
po__qadi03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
po__qadt01
|
|
|
99/99/99
|
|
|
|
po_ap_acct
|
AP Acct
|
|
x(8)
|
|
|
|
po_ap_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
po_ap_sub
|
AP Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
po_app_owner
|
Owner Application
|
|
x(12)
|
|
|
|
po_bank
|
Bank
|
|
x(2)
|
|
|
|
po_bill
|
Bill-To
|
|
x(8)
|
|
|
|
po_blanket
|
Blanket Order
|
Blanket
|
x(8)
|
|
|
|
po_buyer
|
Buyer
|
|
x(8)
|
|
|
|
po_cls_date
|
Close Date
|
Closed
|
99/99/99
|
|
|
|
po_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
po_confirm
|
Confirming
|
Confirm
|
yes/no
|
|
|
|
po_consign_cost_point
|
PO Cost Point
|
|
X(8)
|
0
|
|
|
po_consignment
|
Consignment
|
|
yes/no
|
|
|
|
po_contact
|
Contact
|
|
x(24)
|
|
|
|
po_contract
|
Contract
|
|
x(18)
|
|
|
|
po_cr_terms
|
Credit Terms
|
Terms
|
x(8)
|
|
|
|
po_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
po_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
po_cycl
|
Cycle Code
|
Cycl
|
x(2)
|
|
|
|
po_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
po_del_to
|
Deliver To
|
Delv To
|
x(4)
|
|
|
|
po_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
po_domain
|
Domain
|
|
x(8)
|
|
|
|
po_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
po_duty_type
|
Duty Type
|
Dty
|
x(1)
|
|
|
|
po_eff_strt
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
po_eff_to
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
po_ent_ex
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
po_ers_opt
|
ERS Option
|
ERS!Opt
|
x(2)
|
|
|
|
po_est_value
|
Est Value
|
Est Val
|
->>,>>>,>>9.99
|
10
|
|
|
po_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
po_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
po_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
po_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
po_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
po_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
po_fob
|
FOB
|
|
x(20)
|
|
|
|
po_frt
|
Freight
|
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
po_fst_id
|
FST ID
|
|
x(18)
|
|
|
|
po_incl_iss
|
Include Saturday/Sunday
|
|
yes/no
|
|
|
|
po_inv_mthd
|
Invoices Via
|
|
x(1)
|
|
|
|
po_is_btb
|
EMT PO
|
|
yes/no
|
|
|
|
po_lang
|
Language
|
|
x(2)
|
|
|
|
po_max_aging_days
|
Maximum Aging Days
|
Maximum!Aging Days
|
>>9
|
|
|
|
po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
po_nrm
|
Sequence ID
|
Seq ID
|
x(8)
|
|
|
|
po_ord_date
|
Order Date
|
Date
|
99/99/99
|
|
|
|
po_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
po_pr_list
|
Disc Tbl
|
|
x(8)
|
|
|
|
po_pr_list2
|
Price Tbl
|
Pr Tbl
|
x(8)
|
|
|
|
po_pr_lst_tp
|
ERS Price List Option
|
ERS!PLO
|
>9
|
|
|
|
po_prepaid
|
Amount Prepaid
|
Prepaid
|
->,>>>,>>>,>>9.99
|
10
|
|
|
po_priced_dt
|
Last Price Dt
|
Last Pri
|
99/99/99
|
|
|
|
po_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
po_print
|
Print PO
|
Print
|
yes/no
|
|
|
|
po_project
|
Project
|
|
x(8)
|
|
|
|
po_pst
|
PST
|
|
yes/no
|
|
|
|
po_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
po_recurr
|
Recurr
|
Recu
|
yes/no
|
|
|
|
po_rel_nbr
|
Rel
|
|
>>9
|
|
|
|
po_release
|
Release
|
Rel
|
yes/no
|
|
|
|
po_req_id
|
Req By
|
|
x(8)
|
|
|
|
po_rev
|
Order Revision
|
Order Rev
|
>>9
|
10
|
|
|
po_rev_date
|
Order Revision Date
|
Order Rev Date
|
99/99/99
|
|
|
|
po_rmks
|
Remarks
|
|
x(40)
|
|
|
|
po_sch_mthd
|
Schedules Via
|
|
x(1)
|
|
|
|
po_sched
|
Scheduled
|
|
yes/no
|
|
|
|
po_sd_pat
|
Ship/Dlvy Pattern
|
|
x(2)
|
|
|
|
po_sdt_code
|
SDT Code
|
|
X(3)
|
|
|
|
po_serv_chg
|
Service Charge
|
Service
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_ship
|
Ship-To
|
|
x(8)
|
|
|
|
po_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
po_site
|
Site
|
|
x(8)
|
|
|
|
po_so_hold
|
Secondary SO Cr Hold
|
SO Cr Hd
|
yes/no
|
|
|
|
po_so_nbr
|
Primary SO
|
Pr SO
|
x(8)
|
|
|
|
po_spec_chg
|
Special Charge
|
Special
|
-z,zzz,zzz,zz9.99
|
10
|
|
|
po_stat
|
Status
|
St
|
x(2)
|
|
|
|
po_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
po_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
po_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
po_tax_pct[3]
|
Tax
|
|
->9.99<%
|
10
|
|
|
po_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
po_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
po_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
po_tot_terms_code
|
Terms of Trade
|
|
x(8)
|
|
|
|
po_trade_sale
|
Trade Sales Contract
|
|
yes/no
|
|
|
|
po_trade_sale_so
|
Trade Sales SO
|
TS SO
|
x(8)
|
|
|
|
po_translt_days
|
Transport Days
|
|
>>9.99
|
10
|
|
|
po_type
|
Type
|
Tp
|
x(1)
|
|
|
|
po_user_id
|
Entered By
|
Ent By
|
x(8)
|
|
|
|
po_user1
|
Ufld1
|
|
x(8)
|
|
|
|
po_user2
|
Ufld2
|
|
x(8)
|
|
|
|
po_vend
|
Supplier
|
|
x(8)
|
|
|
|
po_xmit
|
Transm
|
|
X
|
|
|
|
po_zero_sched
|
Zero Schedules
|
Zero Schedules
|
>>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_po_mstr
|
yes
|
oid_po_mstr
|
yes
|
no
|
|
|
po_buyer
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_buyer
|
yes
|
no
|
|
|
|
|
po_vend
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_fsm_type
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_fsm_type
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
∗
|
po_nbr
|
yes
|
po_domain
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_type
|
yes
|
po_domain
|
yes
|
no
|
|
|
|
|
po_type
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
po_vend
|
no
|
po_domain
|
yes
|
no
|
|
|
|
|
po_vend
|
yes
|
no
|
|
|
|
|
po_nbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pp_plan
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pp__qadc01
|
|
|
x(8)
|
|
|
|
pp_bklg_act[12]
|
Bklog Actual
|
Bklog Act
|
->>,>>9.9
|
10
|
|
|
pp_bklg_fcst
|
Bklog Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_cost_act[12]
|
Cost Actual
|
Cost Act
|
->>,>>9.9
|
10
|
|
|
pp_cost_fcst[12]
|
Cost Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_domain
|
Domain
|
|
x(8)
|
|
|
|
pp_inv_act[12]
|
Inv Actual
|
Inv Act
|
->>,>>9.9
|
10
|
|
|
pp_inv_fcst
|
Inv Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_ord_act[12]
|
Order Actual
|
Order Act
|
->>,>>9.9
|
10
|
|
|
pp_ord_fcst[12]
|
Order Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_prod_act[12]
|
Prod Actual
|
Prod Act
|
->>,>>9.9
|
10
|
|
|
pp_prod_fcst[12]
|
Prod Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_prod_line
|
Prod Line
|
|
x(4)
|
|
|
|
pp_ship_act[12]
|
Ship Actual
|
Ship Act
|
->>,>>9.9
|
10
|
|
|
pp_ship_fcst[12]
|
Ship Plan
|
|
->>,>>9.9
|
10
|
|
|
pp_site
|
Site
|
|
x(8)
|
|
|
|
pp_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pp_user2
|
Ufld2
|
|
x(8)
|
|
|
|
pp_year
|
Year
|
|
>>>>
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pp_plan
|
yes
|
oid_pp_plan
|
yes
|
no
|
|
∗
|
pp_plan
|
yes
|
pp_domain
|
yes
|
no
|
|
|
|
|
pp_site
|
yes
|
no
|
|
|
|
|
pp_prod_line
|
yes
|
no
|
|
|
|
|
pp_year
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_pq_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
pq__qadc01
|
|
|
x(8)
|
|
|
|
pq_domain
|
Domain
|
|
x(8)
|
|
|
|
pq_end
|
End Date
|
End
|
99/99/99
|
|
|
|
pq_lead
|
LT(Months)
|
LT
|
>>9
|
|
|
|
pq_lt_off
|
Offset
|
|
->>9
|
|
|
|
pq_prod_line
|
Product Line
|
Line
|
x(4)
|
|
|
|
pq_qty_per
|
Quantity Per
|
Qty Per
|
->>>>,>>9.9<<<<<<<
|
10
|
|
|
pq_ref
|
Reference
|
|
x(8)
|
|
|
|
pq_rsc
|
Resource
|
|
x(8)
|
|
|
|
pq_site
|
Site
|
|
x(8)
|
|
|
|
pq_start
|
Start Date
|
Start
|
99/99/99
|
|
|
|
pq_user1
|
Ufld1
|
|
x(8)
|
|
|
|
pq_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_pq_mstr
|
yes
|
oid_pq_mstr
|
yes
|
no
|
|
∗
|
pq_mstr
|
yes
|
pq_domain
|
yes
|
no
|
|
|
|
|
pq_prod_line
|
yes
|
no
|
|
|
|
|
pq_site
|
yes
|
no
|
|
|
|
|
pq_rsc
|
yes
|
no
|
|
|
|
|
pq_ref
|
yes
|
no
|
|
|
|
|
pq_start
|
yes
|
no
|
|
|
pq_rsc
|
no
|
pq_domain
|
yes
|
no
|
|
|
|
|
pq_rsc
|
yes
|
no
|
|
|
|
|
pq_site
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prd__qad01
|
|
|
x(8)
|
|
|
|
prd_blank
|
Blank Lines/Page
|
BLPP
|
>>9
|
|
|
|
prd_desc
|
Description
|
|
x(24)
|
|
|
|
prd_dest_type
|
Destination Type
|
|
>9
|
|
|
|
prd_dev
|
Output To
|
|
x(8)
|
|
|
|
prd_end_bc
|
Bar Code End Ctrl
|
|
x(100)
|
|
|
|
prd_init
|
Initialize Ctrl
|
|
x(100)
|
|
|
|
prd_init_pro
|
Initialize Command
|
|
x(50)
|
|
|
|
prd_length
|
Lines / Page
|
LPP
|
>>>9
|
|
|
|
prd_mapterm
|
Map To
|
|
x(8)
|
|
|
|
prd_max_page
|
Max Pages
|
|
>>>>9
|
|
|
|
prd_neg_line
|
Neg Line Feed Ctrl
|
|
x(100)
|
|
|
|
prd_page
|
Page Control
|
|
x(60)
|
|
|
|
prd_path
|
Device Pathname
|
|
x(40)
|
|
|
|
prd_reset
|
Reset Ctrl
|
|
x(100)
|
|
|
|
prd_rset_pro
|
Reset Command
|
|
x(50)
|
|
|
|
prd_scroll_only
|
Scroll Output
|
Scroll
|
yes/no
|
|
|
|
prd_spooler
|
Spooler
|
Spool
|
yes/no
|
|
|
|
prd_st_132
|
132-Column Start Ctrl
|
|
x(100)
|
|
|
|
prd_st_80
|
80-Column Start Ctrl
|
|
x(100)
|
|
|
|
prd_st_bc
|
Bar Code Start Ctrl
|
|
x(100)
|
|
|
|
prd_type
|
Printer Type
|
Type
|
x(8)
|
|
|
|
prd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
prd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prd_det
|
yes
|
oid_prd_det
|
yes
|
no
|
|
∗
|
prd_dev
|
yes
|
prd_dev
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CodeValue
|
Code Value
|
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Enforce
|
Enforce
|
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_PrefixC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PrefValue
|
Prefix
|
Pref
|
x(4)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
ScanField
|
Scan Field
|
Scan Field
|
x(20)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_PrefixC
|
yes
|
oid_PrefixC
|
yes
|
no
|
|
∗
|
ScanField
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
ScanField
|
yes
|
no
|
|
|
|
|
PrefValue
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_lgd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_prh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prh__chr01
|
|
|
x(8)
|
|
|
|
prh__chr02
|
|
|
x(8)
|
|
|
|
prh__chr03
|
|
|
x(8)
|
|
|
|
prh__chr04
|
|
|
x(8)
|
|
|
|
prh__chr05
|
|
|
x(8)
|
|
|
|
prh__chr06
|
|
|
x(8)
|
|
|
|
prh__chr07
|
|
|
x(8)
|
|
|
|
prh__chr08
|
|
|
x(8)
|
|
|
|
prh__chr09
|
|
|
x(8)
|
|
|
|
prh__chr10
|
|
|
x(8)
|
|
|
|
prh__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
prh__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
prh__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
prh__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
prh__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
prh__dte01
|
|
|
99/99/99
|
|
|
|
prh__dte02
|
|
|
99/99/99
|
|
|
|
prh__dte03
|
|
|
99/99/99
|
|
|
|
prh__dte04
|
|
|
99/99/99
|
|
|
|
prh__dte05
|
|
|
99/99/99
|
|
|
|
prh__log01
|
|
|
yes/no
|
|
|
|
prh__log02
|
|
|
yes/no
|
|
|
|
prh__qad02
|
|
|
x(8)
|
|
|
|
prh__qad03
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh__qad04
|
|
|
>>>>>>>>
|
|
|
|
prh__qadc01
|
|
|
x(24)
|
|
|
|
prh__qadc02
|
|
|
x(24)
|
|
|
|
prh__qadc03
|
|
|
x(24)
|
|
|
|
prh__qadc04
|
|
|
x(24)
|
|
|
|
prh__qadc05
|
|
|
x(24)
|
|
|
|
prh__qadc06
|
|
|
x(24)
|
|
|
|
prh__qadd01
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh__qadi01
|
|
|
->>>>>>>9
|
|
|
|
prh_approve
|
Approved By
|
Approved
|
x(8)
|
|
|
|
prh_bank
|
Bank
|
|
x(2)
|
|
|
|
prh_bdn_std
|
Std Bdn Cost
|
Std Burden
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_bo_qty
|
Back Order Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_buyer
|
Buyer
|
|
x(8)
|
|
|
|
prh_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
prh_cst_up
|
Update Current Cost
|
|
yes/no
|
|
|
|
prh_cum_rcvd
|
Cum Received
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_cum_req
|
Cum Qty Required
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
prh_curr_amt
|
Currency Amt
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_curr_rlse_id[3]
|
Active Rlse ID
|
|
x(30)
|
|
|
|
prh_domain
|
Domain
|
|
x(8)
|
|
|
|
prh_element
|
Cost Element
|
Element
|
x(8)
|
|
|
|
prh_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prh_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prh_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
prh_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
prh_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
prh_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
prh_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
prh_lbr_std
|
Std Lbr Cost
|
Std Labor
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_line
|
PO Line
|
Ln
|
>>9
|
|
|
|
prh_lot
|
Work Order ID
|
WO ID
|
x(8)
|
|
|
|
prh_mtl_std
|
Std Mtl Cost
|
Std Mtl
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_nbr
|
Order
|
PO
|
x(8)
|
|
|
|
prh_ovh_std
|
Std Ovhead
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
prh_part
|
Item Number
|
|
x(18)
|
|
|
|
prh_pay_um
|
Pay UM
|
UM
|
x(2)
|
|
|
|
prh_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
prh_po_site
|
PO Site
|
|
x(8)
|
|
|
|
prh_print
|
Print Receiver
|
|
yes/no
|
|
|
|
prh_ps_nbr
|
Packing Slip
|
|
x(20)
|
|
|
|
prh_ps_qty
|
Packing Slip Qty
|
Pack Slip Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_pum_conv
|
Pay UM Conv
|
|
>>>>9.9999<<<<
|
10
|
|
|
prh_pur_cost
|
PO Cost
|
|
->,>>>,>>>,>>9.99<<<
|
10
|
|
|
prh_pur_std
|
PO Std Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_qty_ord
|
Qty Ordered
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_rcp_date
|
Receipt Date
|
Receipt
|
99/99/99
|
|
|
|
prh_rcp_type
|
Receipt Type
|
R
|
x(1)
|
|
|
|
prh_rcvd
|
Receipt Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
prh_reason
|
Reason
|
|
x(8)
|
|
|
|
prh_receiver
|
Receiver
|
|
x(8)
|
|
|
|
prh_request
|
Requested By
|
Req By
|
x(8)
|
|
|
|
prh_rev
|
Revision
|
Rev
|
x(4)
|
|
|
|
prh_rma_type
|
RMA Type
|
|
x(1)
|
|
|
|
prh_ship
|
Ship-To
|
|
x(8)
|
|
|
|
prh_ship_date
|
Ship Date
|
Ship!Date
|
99/99/99
|
|
|
|
prh_shipto
|
Ship-to
|
|
x(8)
|
|
|
|
prh_site
|
Site
|
|
x(8)
|
|
|
|
prh_sub_std
|
STD Sub Cost
|
Std Sub
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
prh_tax_at
|
Tax
|
|
x(3)
|
|
|
|
prh_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
prh_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
prh_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
prh_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
prh_type
|
Purchase Type
|
T
|
x(1)
|
|
|
|
prh_um
|
UM
|
|
x(2)
|
|
|
|
prh_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
prh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
prh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
prh_vend
|
Supplier
|
|
x(8)
|
|
|
|
prh_vend_lot
|
Supplier Lot
|
|
x(18)
|
|
|
|
prh_xinv_cst
|
Not Used
|
|
->,>>>,>>>,>>9.99<<<
|
10
|
|
|
prh_xinv_dt
|
Not Used
|
|
99/99/99
|
|
|
|
prh_xinvoice
|
Not Used
|
|
x(12)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prh_hist
|
yes
|
oid_prh_hist
|
yes
|
no
|
|
|
prh_buyer
|
no
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_buyer
|
yes
|
no
|
|
|
|
|
prh_vend
|
yes
|
no
|
|
|
|
|
prh_part
|
yes
|
no
|
|
∗
|
prh_nbr
|
yes
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_nbr
|
yes
|
no
|
|
|
|
|
prh_receiver
|
yes
|
no
|
|
|
|
|
prh_line
|
yes
|
no
|
|
|
|
|
prh_element
|
yes
|
no
|
|
|
prh_oid_lgd_mstr
|
no
|
oid_lgd_mstr
|
yes
|
no
|
|
|
prh_part
|
no
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_part
|
yes
|
no
|
|
|
|
|
prh_rcp_date
|
yes
|
no
|
|
|
prh_ps_nbr
|
no
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_vend
|
yes
|
no
|
|
|
|
|
prh_ps_nbr
|
yes
|
no
|
|
|
|
|
prh_part
|
yes
|
no
|
|
|
prh_rcp_date
|
no
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_rcp_date
|
yes
|
no
|
|
|
prh_receiver
|
yes
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_receiver
|
yes
|
no
|
|
|
|
|
prh_line
|
yes
|
no
|
|
|
prh_vend
|
no
|
prh_domain
|
yes
|
no
|
|
|
|
|
prh_vend
|
yes
|
no
|
|
|
|
|
prh_part
|
yes
|
no
|
|
|
|
|
prh_rcp_date
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prj_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prj__dec01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__dte01
|
|
|
99/99/99
|
|
|
|
prj__log01
|
|
|
yes/no
|
|
|
|
prj__qadc01
|
|
|
x(24)
|
|
|
|
prj__qadc02
|
|
|
x(24)
|
|
|
|
prj__qadd01
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__qadd02
|
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj__qadi01
|
|
|
>>>>>>>9
|
|
|
|
prj__qadi02
|
|
|
>>>>>>>9
|
|
|
|
prj__qadl01
|
|
|
yes/no
|
|
|
|
prj__qadl02
|
|
|
yes/no
|
|
|
|
prj__qadt01
|
|
|
99/99/99
|
|
|
|
prj__qadt02
|
|
|
99/99/99
|
|
|
|
prj_action_stat
|
Action Status
|
|
x(2)
|
|
|
|
prj_ar_acct
|
AR Account
|
|
x(8)
|
|
|
|
prj_ar_cc
|
AR Cost Center
|
|
x(4)
|
|
|
|
prj_ar_sub
|
AR Sub-Account
|
|
x(8)
|
|
|
|
prj_bg_above
|
Budget Overrun Limit
|
|
->>9.9<%
|
10
|
|
|
prj_bg_below
|
Budget Warning Limit
|
|
->>9.9<%
|
10
|
|
|
prj_bill_to
|
Bill-To
|
|
x(8)
|
|
|
|
prj_channel
|
Channel
|
|
x(8)
|
|
|
|
prj_close_date
|
Close Date
|
|
99/99/99
|
|
|
|
prj_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
prj_comm_pct[4]
|
Commission
|
|
>>9.9<%
|
10
|
|
|
prj_cr_card
|
Credit Card
|
|
x(2)
|
|
|
|
prj_cr_init
|
Cr Initials
|
|
x(3)
|
|
|
|
prj_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
prj_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
prj_cust
|
Sold-To
|
|
x(8)
|
|
|
|
prj_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
prj_desc
|
Desc
|
|
x(24)
|
|
|
|
prj_domain
|
Domain
|
|
x(8)
|
|
|
|
prj_end_date
|
End Date
|
|
99/99/99
|
|
|
|
prj_eng_nbr
|
Engineer
|
|
x(8)
|
|
|
|
prj_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
prj_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prj_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
prj_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
prj_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
prj_fix_rate
|
Fixed Rate
|
|
yes/no
|
|
|
|
prj_global_inv
|
Global Invoicing
|
|
yes/no
|
|
|
|
prj_inv_det
|
Details on Invoice
|
|
yes/no
|
|
|
|
prj_inv_det_pr
|
Price Details on Invoice
|
|
yes/no
|
|
|
|
prj_inv_lvl
|
Invoice Level
|
|
yes/no
|
|
|
|
prj_lang
|
Language
|
|
x(2)
|
|
|
|
prj_loc
|
Location
|
|
x(8)
|
|
|
|
prj_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
prj_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
prj_mref
|
Master Project
|
|
x(8)
|
|
|
|
prj_nbr
|
Project
|
|
x(8)
|
|
|
|
prj_ord_date
|
Order Date
|
|
99/99/99
|
|
|
|
prj_pjt_code
|
Project Type
|
|
x(8)
|
|
|
|
prj_po
|
Purchase Order
|
|
x(22)
|
|
|
|
prj_pr_list
|
Price List
|
|
x(8)
|
|
|
|
prj_pr_rollup
|
Auto Price Rollup
|
|
yes/no
|
|
|
|
prj_prep_tax
|
Prepaid Tax
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj_prepaid
|
Prepaid
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
prj_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
prj_rmks
|
Remarks
|
|
x(40)
|
|
|
|
prj_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
prj_ship_to
|
Ship-To
|
|
x(8)
|
|
|
|
prj_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
prj_site
|
Site
|
|
x(8)
|
|
|
|
prj_slspsn[4]
|
Slsperson
|
|
x(8)
|
|
|
|
prj_st_date
|
Start Date
|
|
99/99/99
|
|
|
|
prj_status
|
Status
|
|
x(8)
|
|
|
|
prj_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
prj_tax_env
|
Tax Environment
|
|
x(16)
|
|
|
|
prj_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
prj_tax_usage
|
Tax Usage
|
|
x(8)
|
|
|
|
prj_taxable
|
Taxable
|
|
yes/no
|
|
|
|
prj_taxc
|
Tax Environment Tax Class
|
|
x(3)
|
|
|
|
prj_trl1_amt
|
Trailer Amt 1
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl1_cd
|
Trailer 1
|
|
x(2)
|
|
|
|
prj_trl2_amt
|
Trailer Amt 2
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl2_cd
|
Trailer 2
|
|
x(2)
|
|
|
|
prj_trl3_amt
|
Trailer Amt 3
|
|
-zzzz,zzz,zz9.99
|
10
|
|
|
prj_trl3_cd
|
Trailer 3
|
|
x(2)
|
|
|
|
prj_type_taxc
|
Tax Rate Tax Class
|
|
x(3)
|
|
|
|
prj_use_budgets
|
Use Budgets
|
|
yes/no
|
|
|
|
prj_user1
|
Ufld1
|
|
x(8)
|
|
|
|
prj_user2
|
Ufld2
|
|
x(8)
|
|
|
|
prj_userid
|
Entered By
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prj_mstr
|
yes
|
oid_prj_mstr
|
yes
|
no
|
|
∗
|
prj_nbr
|
yes
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_nbr
|
yes
|
no
|
|
|
prj_pjt_code
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_pjt_code
|
yes
|
no
|
|
|
prj_po
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_po
|
yes
|
no
|
|
|
|
|
prj_cust
|
yes
|
no
|
|
|
prj_ship
|
no
|
prj_domain
|
yes
|
no
|
|
|
|
|
prj_ship_to
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_profd_det
|
OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
profd__qadc01
|
|
|
x(24)
|
|
|
|
profd__qadc02
|
|
|
x(24)
|
|
|
|
profd__qadc03
|
|
|
x(24)
|
|
|
|
profd__qadc04
|
|
|
x(24)
|
|
|
|
profd__qadl01
|
|
|
yes/no
|
|
|
|
profd__qadl02
|
|
|
yes/no
|
|
|
|
profd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
profd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
profd_name
|
Detail Name
|
|
x(32)
|
|
|
|
profd_prof_name
|
Profile Name
|
|
x(20)
|
|
|
|
profd_type
|
Type
|
|
>9
|
|
|
|
profd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
profd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
profd_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
profd_userc04
|
User Field Character 4
|
|
x(24)
|
|
|
|
profd_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
profd_userl02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_profd_det
|
yes
|
oid_profd_det
|
yes
|
no
|
|
∗
|
profd_name
|
yes
|
profd_prof_name
|
yes
|
no
|
|
|
|
|
profd_name
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Profile_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ProfileCode
|
Profile Code
|
|
x(20)
|
|
|
|
ProfileDescription
|
Description
|
|
x(40)
|
|
|
|
ProfileIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
ProfileTypeCode
|
Profile Type
|
|
x(30)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
ProfileCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Profile_ID
|
yes
|
no
|
|
|
Type
|
no
|
ProfileTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
ProfileIsActive
|
yes
|
no
|
|
|
|
|
ProfileCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Profile_ID
|
Link to Profile
|
|
-99999999999
|
|
|
|
ProfileLink_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ProfileLinkObject_ID
|
Linked Object
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ProfileLink_ID
|
yes
|
no
|
|
|
Profile
|
no
|
Profile_ID
|
yes
|
no
|
|
|
ProfileLinkObject
|
no
|
ProfileLinkObject_ID
|
yes
|
no
|
|
|
ProfileSharedSet
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
Profile_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ProfileTypeCode
|
Profile Type Code
|
|
x(30)
|
|
|
|
ProfileTypeIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
ProfileTypeIsDefault
|
Default
|
|
yes/no
|
|
|
|
ProfileTypeTranslated
|
Profile Type Code
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSetTypeCode
|
Shared Set Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ProfileTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
ProfileTypeIsActive
|
yes
|
no
|
|
|
|
|
ProfileTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_prof_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
prof__qadc01
|
|
|
x(24)
|
|
|
|
prof__qadc02
|
|
|
x(24)
|
|
|
|
prof__qadc03
|
|
|
x(24)
|
|
|
|
prof__qadc04
|
|
|
x(24)
|
|
|
|
prof__qadl01
|
|
|
yes/no
|
|
|
|
prof__qadl02
|
|
|
yes/no
|
|
|
|
prof_desc
|
Description
|
|
x(24)
|
|
|
|
prof_func
|
Function
|
|
x(20)
|
|
|
|
prof_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
prof_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
prof_name
|
Name
|
|
x(40)
|
|
|
|
prof_order
|
Order
|
|
->,>>>,>>9
|
|
|
|
prof_pgm
|
Program
|
|
x(80)
|
|
|
|
prof_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
prof_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
prof_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
prof_userc04
|
User Field Character 4
|
|
x(24)
|
|
|
|
prof_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
prof_userl02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_prof_mstr
|
yes
|
oid_prof_mstr
|
yes
|
no
|
|
∗
|
prof_func
|
yes
|
prof_func
|
yes
|
no
|
|
|
|
|
prof_name
|
yes
|
no
|
|
|
prof_name
|
yes
|
prof_name
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AdminRespUsr_ID
|
Responsible
|
|
-99999999999
|
|
|
|
BudgetGroup_ID
|
Budget Group
|
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
COAMaskProjProfile_ID
|
COA Mask Profile
|
|
-99999999999
|
|
|
|
ControllerUsr_ID
|
Login
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Debtor_ID
|
Customer
|
|
-99999999999
|
|
|
|
Division_ID
|
Link to Division
|
|
-99999999999
|
|
|
|
DivisionProfile_ID
|
Sub-Account Profile
|
|
-99999999999
|
|
|
|
ExchangeRateType_ID
|
Exchange Rate Type
|
Rate Type
|
-99999999999
|
|
|
|
Industry_ID
|
Link to Industry
|
|
-99999999999
|
|
|
|
InvoiceAddress_ID
|
City
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
MainProject_ID
|
Main Project
|
|
-99999999999
|
|
|
|
ObsoletePriceList_ID
|
Link to Price List
|
|
-99999999999
|
|
|
|
ObsoleteRevenueRecogType
|
Revenue Recognition Type
|
|
x(20)
|
|
|
|
PaymentCondition_ID
|
Credit Terms
|
Cred Trm
|
-99999999999
|
|
|
|
PenholderCompany_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Project_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ProjectCode
|
Project
|
|
x(8)
|
|
|
|
ProjectContractAmountTC
|
TC Contract Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
ProjectContractDate
|
Contract Date
|
|
99/99/9999
|
|
|
|
ProjectContractReference
|
Contract Reference
|
Contract Ref
|
x(40)
|
|
|
|
ProjectDateRevised
|
Date Revised
|
Project Date Revised
|
99/99/9999
|
|
|
|
ProjectDescription
|
Description
|
|
x(24)
|
|
|
|
ProjectEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
ProjectGroup_ID
|
Project Group
|
|
-99999999999
|
|
|
|
ProjectIsAltRevProdCalc
|
Alt Production Calculation
|
|
yes/no
|
|
|
|
ProjectIsStructFromGL
|
Retrieve SAF Structure from GL
|
Retrieve Structure from GL
|
yes/no
|
|
|
|
ProjectIsTemplate
|
Save as Template
|
Template
|
yes/no
|
|
|
|
ProjectIsWithSaf
|
SAF Enabled
|
SAF
|
yes/no
|
|
|
|
ProjectManagerUsr_ID
|
Project Administrator
|
Project Administrator
|
-99999999999
|
|
|
|
ProjectOriginalCompletDate
|
Original Completion Date
|
Proj Orig Comp Date
|
99/99/9999
|
|
|
|
ProjectPriceTypeCode
|
Price Type
|
|
x(20)
|
|
|
|
ProjectRevisedCompletDate
|
Revised Completion Date
|
Proj Rev Comp Date
|
99/99/9999
|
|
|
|
ProjectSafSetOnByUsr_ID
|
Link to Usr
|
|
-99999999999
|
|
|
|
ProjectSafSetOnOnDate
|
SAF Set on Date
|
|
99/99/9999
|
|
|
|
ProjectStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ProjectStatus_ID
|
Status Code
|
|
-99999999999
|
|
|
|
ProjectSystemStatus
|
System Status
|
|
x(20)
|
|
|
|
ProjectTypeCode
|
Project Type
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Region_ID
|
Region
|
|
-99999999999
|
|
|
|
SalesRespUsr_ID
|
Login
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
SiteAddress_ID
|
Address
|
|
-99999999999
|
|
|
|
TemplateProject_ID
|
Template Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AdmUsrIdx
|
no
|
AdminRespUsr_ID
|
yes
|
no
|
|
|
BudgetGroup
|
no
|
BudgetGroup_ID
|
yes
|
no
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
COAMaskProfileIdx
|
no
|
COAMaskProjProfile_ID
|
yes
|
no
|
|
|
Code
|
no
|
ProjectCode
|
yes
|
no
|
|
|
ContolUsrIdx
|
no
|
ControllerUsr_ID
|
yes
|
no
|
|
|
CurrencyIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DebtorIdx
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
Division_ID
|
yes
|
no
|
|
|
DivProfileIdx
|
no
|
DivisionProfile_ID
|
yes
|
no
|
|
|
ExRateTypeIdx
|
no
|
ExchangeRateType_ID
|
yes
|
no
|
|
|
IndustryIdx
|
no
|
Industry_ID
|
yes
|
no
|
|
|
InvAddrIdx
|
no
|
InvoiceAddress_ID
|
yes
|
no
|
|
|
IsTemplate
|
no
|
ProjectIsTemplate
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
MainPrjIdx
|
no
|
MainProject_ID
|
yes
|
no
|
|
|
PayCondIdx
|
no
|
PaymentCondition_ID
|
yes
|
no
|
|
|
PenHoldCyIdx
|
no
|
PenholderCompany_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Project_ID
|
yes
|
no
|
|
|
PrjManUsrIdx
|
no
|
ProjectManagerUsr_ID
|
yes
|
no
|
|
|
PrjSafOnUsrIdx
|
no
|
ProjectSafSetOnByUsr_ID
|
yes
|
no
|
|
|
PrjStatIdx
|
no
|
ProjectStatus_ID
|
yes
|
no
|
|
|
ProjectGroup
|
no
|
ProjectGroup_ID
|
yes
|
no
|
|
|
ProjectSystemStatus
|
no
|
ProjectSystemStatus
|
yes
|
no
|
|
|
RegionIdx
|
no
|
Region_ID
|
yes
|
no
|
|
|
SalesRepUsrIdx
|
no
|
SalesRespUsr_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
ProjectCode
|
yes
|
no
|
|
|
SiteAddrIdx
|
no
|
SiteAddress_ID
|
yes
|
no
|
|
|
TemplatePrjIdx
|
no
|
TemplateProject_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ProjectGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ProjectGroupCode
|
Code
|
|
x(20)
|
|
|
|
ProjectGroupDescription
|
Description
|
|
x(40)
|
|
|
|
ProjectGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
ProjectGroupIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ProjectGroup_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
ProjectGroupCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
ProjectGroupIsActive
|
yes
|
no
|
|
|
|
|
ProjectGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Project_ID
|
Link to Project
|
|
-99999999999
|
|
|
|
ProjectSafDefault_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ProjectSafDefault_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafConcept
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Project_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ProjectStatus_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ProjectStatusCode
|
Status Code
|
|
x(20)
|
|
|
|
ProjectStatusDescription
|
Description
|
Status Description
|
x(40)
|
|
|
|
ProjectStatusIsActive
|
Active
|
|
yes/no
|
|
|
|
ProjectStatusSystemStatus
|
System Status
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
ProjectStatusCode
|
yes
|
no
|
|
|
IsActive
|
no
|
ProjectStatusIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ProjectStatus_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
ProjectStatusIsActive
|
yes
|
no
|
|
|
|
|
ProjectStatusCode
|
yes
|
no
|