QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
BankStateLine
Bank Statement Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankState_ID
Link to BankState
 
-99999999999
 
 
BankStateLine_ID
Record ID
 
-99999999999
 
 
BankStateLineAmountTC
TC Amount
 
->>>,>>>,>>>,>>9.99
4
 
BankStateLineBankImpRef
Bank Importing Reference
 
x(255)
 
 
BankStateLineDescription
Description
 
x(255)
 
 
BankStateLineExtAddress
Address (Ext)
 
x(40)
 
 
BankStateLineExtBankNumber
Bank Number (Ext)
 
x(40)
 
 
BankStateLineExtBankRate
Bank Rate (Ext)
 
->,>>>,>>9.9999999999
10
 
BankStateLineExtCity
City (Ext)
 
x(40)
 
 
BankStateLineExtCostCode
Cost Code (Ext)
 
x(20)
 
 
BankStateLineExtCountry
Country (Ext)
 
x(20)
 
 
BankStateLineExtCurrency
Currency (Ext)
 
x(20)
 
 
BankStateLineExtDebCred
Customer/Supplier (Ext)
 
x(20)
 
 
BankStateLineExtName
Name (Ext)
 
x(40)
 
 
BankStateLineExtOriginalTC
TC Original (Ext)
 
->>>,>>>,>>>,>>9.99
4
 
BankStateLineExtRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
BankStateLineExtReference
Reference (Ext)
 
x(40)
 
 
BankStateLineExtSwiftCode
SWIFT Code (Ext)
 
x(40)
 
 
BankStateLineExtTSM
TSM (Ext)
 
x(40)
 
 
BankStateLineExtZip
Zip Code (Ext)
 
x(20)
 
 
BankStateLineInformation
Information
 
x(2000)
 
 
BankStateLineInOut
In/Out
 
x(20)
 
 
BankStateLineNumber
Number
 
->,>>>,>>9
 
 
BankStateLinePostingDate
Posting Date
 
99/99/9999
 
 
BankStateLineReportingDateIN
Reporting Date (IN)
 
99/99/9999
 
 
BankStateLineStatus
Status
 
x(20)
 
 
BankStateLineValueDate
Value Date
 
99/99/9999
 
 
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)
 
 
Period_ID
GL Calendar Year
GL Cal Year
-99999999999
 
 
Posting_ID
Voucher
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankState
no
BankState_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
CyImpRefIdx
no
Company_ID
yes
no
 
 
 
BankStateLineBankImpRef
yes
no
 
Period
no
Period_ID
yes
no
 
Posting
no
Posting_ID
yes
no
 ∗
Prim
yes
BankStateLine_ID
yes
no
 
Stattus
no
BankStateLineStatus
yes
no
 
UniqueIdx
yes
BankState_ID
yes
no
 
 
 
BankStateLineNumber
yes
no
BankStateStageAlloc
Bank Statement Stage Allocation
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankState_ID
Link to BankState
 
-99999999999
 
 
BankStateAlloc_ID
Link to BankStateAlloc
 
-99999999999
 
 
BankStateStageAlloc_ID
Record ID
 
-99999999999
4
 
BankStateStageAllocAmntTC
Stage Allocation
 
->>>,>>>,>>>,>>9.99
4
 
BankStateStageAllocDiscTC
Stage Discount
 
->>>,>>>,>>>,>>9.99
4
 
BankStateStageAllocPaidTC
Stage Paid
 
->>>,>>>,>>>,>>9.99
4
 
BankStateStageAllocWHTTC
TCWHT Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceStage_ID
Link to CInvoiceStage
 
-99999999999
 
 
DInvoiceStage_ID
Link to DInvoiceStage
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankStAll
no
BankStateAlloc_ID
yes
no
 
BankState
no
BankState_ID
yes
no
 
CIStage
no
CInvoiceStage_ID
yes
no
 
DIStage
no
DInvoiceStage_ID
yes
no
 ∗
Prim
yes
BankStateStageAlloc_ID
yes
no
 
UniqueIdx
yes
BankStateAlloc_ID
yes
no
 
 
 
CInvoiceStage_ID
yes
no
 
 
 
DInvoiceStage_ID
yes
no
BatchPickC
Warehousing Batch Picking Contol
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowMerge
Allow Merge Orders
 
yes/no
 
 
AutoRef
Auto / Manual Sequence ID
 
Auto/Manual
 
 
AutoSel
Auto Selection
 
yes/no
 
 
BlankRef
Blank Reference
 
yes/no
 
 
CloseOpt
Close Option
 
9
 
 
Cmmt_so
Display SO Header Comments
Display SO Header Comments
yes/no
 
 
Cmmt_sod
Display SO Line Comments
Display SO Line Comments
yes/no
 
 
ConsoIRG
Consolidation IRG
Conso!IRG
x(8)
 
 
ContItem
Container Item
 
x(18)
 
 
ContLength
Container Lenght
 
->>,>>9.99
10
 
ContSeqID
Container Sequence ID
 
x(8)
 
 
ContUM
Container UM
UM
x(2)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
DateFormat
Date Format
 
MDY/DMY
 
 
Destination
Default Packing Location
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ExplosionOpt
Explosion Option
 
9
 
 
GenerateID
Generate Identification
 
yes/no
 
 
Include_do
Include Distribution Order
Include DO
yes/no
 
 
Include_so
Include Sales Order
Include SO
yes/no
 
 
Include_wo
Include Work Order
Include WO
yes/no
 
 
LblOpt
Label Print Option
 
9
 
 
LblPrint
Pro-Print/Post-Print
 
9
 
 
LogFormat
Logical Format
Log Frmt
x(8)
 
 
Mandatory
Scan Required
 
yes/no
 
 
MaxPick
Maximum Picked Cases
 
>>9
 
 
MaxSel
Maximum Selection
Max Selection
>>9
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_BatchPickC
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OnlyShipperOpt
Only Shipper Option
 
9
 
 
PalletItem
Pallet Item
Pallet!Item
x(18)
 
 
PalPrintOpt
Pallet Print Option
Pallet!Pr.Opt.
9
 
 
PalPrintProg
Pallet Print Program
Pallet!Pr.Prog
x(10)
 
 
PostPrint
Post Print Option
 
9
 
 
PrAssSh
Assign Shipper Number
 
yes/no
 
 
PrCustAddr
Print Customer Address
 
yes/no
 
 
PreShipSeqID
Preshipper Sequence ID
 
X(8)
 
 
PrFeaOp
Features and Options
 
yes/no
 
 
PrintProg
Label Print Program
 
x(10)
 
 
PrLotNbr
Lot/Serial Numbers
 
yes/no
 
 
PromptRemove
Prompt to Remove Container
 
yes/no
 
 
PrPaOpt
Print Paperwork Option
 
9
 
 
PrPckCmm
Packing List Comments
 
yes/no
 
 
PrQtySoUM
Quantity In SO UM
 
yes/no
 
 
PrShCmm
Shipper Comments
 
yes/no
 
 
PrSoDet
Order Detail
 
yes/no
 
 
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
 
 
ReleaseOpt
Release Orders Option
Rel Ord!Option
9
 
 
ReqLoc
Location Required
 
yes/no
 
 
ReqLot
Lot Required
 
yes/no
 
 
ReqPart
Part Required
 
yes/no
 
 
ReqQty
Quantity Required
 
yes/no
 
 
ReqRef
Reference Required
 
yes/no
 
 
RFHeight
RF Screen Height
RF Height
>9
 
 
ScanLoc
Scan Location
 
yes/no
 
 
ScanLot
Scan Lot/Serial
 
yes/no
 
 
ScanPart
Scan Item
 
yes/no
 
 
ScanQty
Scan Quantity
Scan Qty
yes/no
 
 
ScanRef
Scan Reference
 
yes/no
 
 
Sel
SO Batch Selection
SO Batch Sel
x(12)
 
 
ShipperSeqOpt
Shipper Seq Option
 
9
 
 
SingleLoc
Single Packing Location
 
yes/no
 
 
Site
Site
 
x(8)
 
 
Type
Container / Reference
 
Container/Reference
 
 
UndoAvail
Undo Available
 
yes/no
 
 
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
 
 
WeightUM
Weight UM
UM
x(2)
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_BatchPickC
yes
oid_BatchPickC
yes
no
 ∗
SiteWhse
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
BatchPickD
Warehousing Batch Picking Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_BatchPickD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PickStatus
Status
St
x(12)
 
 
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
 
 
Quantity
Actual
 
->,>>>,>>9.9<<<<<<<<
10
 
Site
Site
 
x(8)
 
 
StartUserID
Start User
 
x(8)
 
 
ToAltUM
To UM
To!UM
x(2)
 
 
ToDigit
To Digit
 
x(8)
 
 
ToLoc
To Location
To Loc
x(8)
 
 
ToLot
To Lot/Serial
 
x(18)
 
 
ToPart
To Item Number
 
x(18)
 
 
ToRef
To Reference
To!Reference
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
ToWhse
To Whse
 
x(8)
 
 
TrNbr
Transaction
Trans
>>>>>>>>>9
 
 
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_BatchPickD
yes
oid_BatchPickD
yes
no
 
StartUserID
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
StartUserID
yes
no
 
ToLoc
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
ToLoc
yes
no
 
ToRef
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
ToRef
yes
no
 ∗
TrNbr
yes
Domain
yes
no
 
 
 
TrNbr
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToWhse
yes
no
 
 
 
ToLoc
yes
no
 
 
 
ToPart
yes
no
 
 
 
ToLot
yes
no
 
 
 
ToRef
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
BatchPickM
Warehousing Batch Picking Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
BatchStatus
Status
St
x(12)
 
 
Complete
Complete
 
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Distance
Travel Sequence
Travel!Sequence
->,>>>,>>9
 
 
Domain
Domain
 
x(8)
 
 
Fail
Fail
 
yes/no
 
 
FromAltUM
From UM
Fr!UM
x(2)
 
 
FromDigit
From Digit
From!Digit
x(8)
 
 
FromLoc
From Location
From!Location
x(8)
 
 
FromLot
From Lot/Serial
 
x(18)
 
 
FromPart
From Item Number
 
x(18)
 
 
FromQty
Actual
 
->,>>>,>>9.9<<<<<<<<
10
 
FromRef
From Reference
From!Reference
x(8)
 
 
FromSite
From Site
From!Site
x(8)
 
 
FromWhse
From Whse
From!Whse
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_BatchPickM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OldUserID
Old User
 
x(8)
 
 
OPCAltUM
OPC UM
OPC!UM
x(2)
 
 
OPCQty
OPC Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
Priority
Priority
 
->,>>>,>>9
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
x(8)
0
 
QadC06
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
 
 
QadI04
QAD Field
QAD Field
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadL03
QAD Field
 
yes/no
 
 
QadL04
QAD Field
 
yes/no
 
 
QadL05
QAD Field
 
yes/no
 
 
QadL06
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
Repick
Repick
 
yes/no
 
 
ScanField
Scan Field
 
x(12)
 
 
Sequence
Sequence
 
->,>>>,>>9
 
 
Site
Site
 
x(8)
 
 
StartDate
Start Date
 
99/99/99
 
 
StartTime
Start Time
 
>>>>>>>9
 
 
StartUserID
Start User
 
x(8)
 
 
ToAltUM
To UM
To!UM
x(2)
 
 
ToDigit
To Digit
 
x(8)
 
 
ToLoc
To Location
To Loc
x(8)
 
 
ToLot
To Lot/Serial
 
x(18)
 
 
ToPart
To Item Number
 
x(18)
 
 
ToRef
To Reference
To!Reference
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
Tote
Tote Number
 
x(12)
 
 
ToteAction
Action
 
->,>>>,>>9
 
 
ToWhse
To Whse
 
x(8)
 
 
TrNbr
Transaction
Trans
>>>>>>>>>9
 
 
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
 
Distance
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
StartUserID
yes
no
 
 
 
Distance
yes
no
 
 
 
FromLoc
yes
no
 
 
 
Priority
no
no
 
FromLoc
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
 
 
FromLoc
yes
no
 
 
 
FromPart
yes
no
 
 
 
FromLot
yes
no
 
 
 
FromRef
yes
no
 
oid_BatchPickM
yes
oid_BatchPickM
yes
no
 
Sequence
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
StartUserID
yes
no
 
 
 
Sequence
yes
no
 
StartUserID
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
StartUserID
yes
no
 
 
 
BatchStatus
yes
no
 ∗
TrNbr
yes
Domain
yes
no
 
 
 
TrNbr
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
bbl_mstr
Brazilian Bank bill
 
 
Field Name
Label
Col-Label
Format
Dec
 
bbl__qadc01
 
 
x(24)
 
 
bbl__qadc02
 
 
x(24)
 
 
bbl__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
bbl__qadt01
 
 
99/99/99
 
 
bbl_bbl_amt
Document Amount
Doc Amt
->>>>,>>>,>>9.99<
10
 
bbl_bk_acct_code
Bank Acct Code
 
x(8)
 
 
bbl_cinvoice_id
Supplier Invoice ID
Supp Inv ID
-99999999999
 
 
bbl_creditor_id
Creditor ID
 
-99999999999
 
 
bbl_domain
Domain
 
x(8)
 
 
bbl_due_date
Due Date
 
99/99/99
 
 
bbl_exec_date
Execution Date
 
99/99/99
 
 
bbl_file_name
Bank File Name
 
x(60)
 
 
bbl_gst_id
Tax ID - Federal
 
x(18)
 
 
bbl_lgd_nbr
Legal Doc Nbr
Legal Doc
x(12)
 
 
bbl_man_bar_code
Manual Bar Code
Man Bar Code
x(47)
 
 
bbl_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
bbl_mod_userid
Last Modified User Id
 
x(8)
 
 
bbl_opt_bar_code
Optical Bar Code
Opt Bar Code
x(44)
 
 
bbl_owner_bk_acct_code
Bank Account Code
 
x(8)
 
 
bbl_receive_date
Received Date
 
99/99/99
 
 
bbl_user1
User Field Character 1
 
x(24)
 
 
bbl_user2
User Field Character 2
 
x(24)
 
 
oid_bbl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
bbl_cinvoice_id
no
bbl_cinvoice_id
yes
no
 
bbl_file_name
no
bbl_domain
yes
no
 
 
 
bbl_file_name
yes
no
bbl_man_bar_code
no
bbl_domain
yes
no
 
 
 
bbl_man_bar_code
yes
no
 
 
 
bbl_file_name
yes
no
 
oid_bbl_mstr
yes
oid_bbl_mstr
yes
no
bcd_det
Batch Control Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
bcd__qadc01
 
 
x(8)
 
 
bcd_batch
Batch ID
 
x(8)
 
 
bcd_date_run
Run Date
Run!Date
99/99/99
 
 
bcd_date_sub
Submit Date
Submit!Date
99/99/99
 
 
bcd_dev
Output
 
x(8)
 
 
bcd_domain
Domain
 
x(8)
 
 
bcd_exec
Program
 
x(14)
 
 
bcd_mnu_nbr
Menu
 
x(16)
 
 
bcd_mnu_sel
Selection
Sel
>9
 
 
bcd_parm
Parameter Data
Parameter!Data
x(200)
 
 
bcd_perm
Permanent
Perm
yes/no
 
 
bcd_priority
Priority
 
>>>,>>9
 
 
bcd_process
Process
 
yes/no
 
 
bcd_run_stat
Run Status
Run!Status
x(8)
 
 
bcd_time_run
Run Time
Run!Time
x(8)
 
 
bcd_time_sub
Submit Time
Submit!Time
x(8)
 
 
bcd_user1
Ufld1
 
x(8)
 
 
bcd_user2
Ufld2
 
x(8)
 
 
bcd_userid
Submitted By
Submitted!By
x(8)
 
 
oid_bcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bcd_id
yes
bcd_domain
yes
no
 
 
 
bcd_batch
yes
no
 
 
 
bcd_date_sub
yes
no
 
 
 
bcd_time_sub
yes
no
 
 
 
bcd_userid
yes
no
 
oid_bcd_det
yes
oid_bcd_det
yes
no
bc_mstr
Batch Control Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
bc__qadc01
 
 
x(8)
 
 
bc_batch
Batch ID
 
x(8)
 
 
bc_canrun
Users/Roles
 
x(189)
 
 
bc_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
bc_desc
Description
 
x(24)
 
 
bc_domain
Domain
 
x(8)
 
 
bc_perm
Permanent
 
yes/no
 
 
bc_priority
Priority
 
>>>,>>9
 
 
bc_user1
Ufld1
 
x(8)
 
 
bc_user2
Ufld2
 
x(8)
 
 
oid_bc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bc_batch
yes
bc_domain
yes
no
 
 
 
bc_batch
yes
no
 
oid_bc_mstr
yes
oid_bc_mstr
yes
no
bdld_det
Batch Data Load Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
bdld__qadc01
 
 
x(8)
 
 
bdld_data
Data
 
x(78)
 
 
bdld_domain
Domain
 
x(8)
 
 
bdld_id
Group Id
 
>>>>>>>9
 
 
bdld_line
Line Number
 
>>>9
 
 
bdld_source
Source
 
x(16)
 
 
bdld_user1
Ufld1
 
x(8)
 
 
bdld_user2
Ufld2
 
x(8)
 
 
oid_bdld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bdld_id
yes
bdld_domain
yes
no
 
 
 
bdld_source
yes
no
 
 
 
bdld_id
yes
no
 
 
 
bdld_line
yes
no
 
oid_bdld_det
yes
oid_bdld_det
yes
no
bdl_mstr
Batch Data Load Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
bdl__qadc01
 
 
x(8)
 
 
bdl_date_ent
Date Entered
 
99/99/99
 
 
bdl_date_pro
Date Processed
 
99/99/99
 
 
bdl_domain
Domain
 
x(8)
 
 
bdl_exec
Program
 
x(16)
 
 
bdl_id
Group Id
 
>>>>>>>9
 
 
bdl_pgm_errs
Program Errors
 
>,>>9
 
 
bdl_pro_errs
Progress Errors
 
>,>>9
 
 
bdl_source
Source ID
 
x(16)
 
 
bdl_time_ent
Time Entered
 
x(8)
 
 
bdl_time_pro
Time Processed
 
x(8)
 
 
bdl_user1
Ufld1
 
x(8)
 
 
bdl_user2
Ufld2
 
x(8)
 
 
oid_bdl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bdl_id
yes
bdl_domain
yes
no
 
 
 
bdl_source
yes
no
 
 
 
bdl_id
yes
no
 
oid_bdl_mstr
yes
oid_bdl_mstr
yes
no
bdp_det
Bank Driver Payment Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
bdp__qadc01
 
 
x(24)
 
 
bdp__qadc02
 
 
x(24)
 
 
bdp__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
bdp__qadi01
 
 
->>>>>>>9
 
 
bdp__qadl01
 
 
yes/no
 
 
bdp__qadt01
 
 
99/99/99
 
 
bdp_addr
Customer/Supplier
 
x(8)
 
 
bdp_bank
Bank
 
x(2)
 
 
bdp_character
Character
 
x(48)
 
 
bdp_date
Date
 
99/99/99
 
 
bdp_decimal
Decimal
 
->>,>>>,>>>,>>9.99<
10
 
bdp_domain
Domain
 
x(8)
 
 
bdp_integer
Integer
 
->,>>>,>>9
 
 
bdp_logical
Logical
 
yes/no
 
 
bdp_mod_date
Modified Date
Mod Date
99/99/99
 
 
bdp_mod_userid
User ID
 
x(8)
 
 
bdp_pay_method
Payment Method
PM
x(2)
 
 
bdp_program
Program
 
x(12)
 
 
bdp_ref
Reference
 
x(8)
 
 
bdp_seq
Sequence
 
999
 
 
bdp_split
Split Payment
Split
yes/no
 
 
bdp_user1
User Field Character 1
 
x(24)
 
 
bdp_user2
User Field Character 2
 
x(24)
 
 
bdp_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
bdp_useri01
User Field Integer 1
 
->>>>>>>9
 
 
bdp_userl01
User Field Logical 1
 
yes/no
 
 
bdp_usert01
User Field Date 1
 
99/99/99
 
 
oid_bdp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bdp_pay_seq
yes
bdp_domain
yes
no
 
 
 
bdp_program
yes
no
 
 
 
bdp_addr
yes
no
 
 
 
bdp_bank
yes
no
 
 
 
bdp_pay_method
yes
no
 
 
 
bdp_ref
yes
no
 
 
 
bdp_seq
yes
no
 
oid_bdp_det
yes
oid_bdp_det
yes
no
bic_ctrl
Service/Support Contract Billing Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
bic__qadc01
 
 
x(8)
 
 
bic__qadi01
 
 
->>>>>>>9
 
 
bic_audit
Audit has been Run
 
yes/no
 
 
bic_domain
Domain
 
x(8)
 
 
bic_last_cyc
Last Cycle Billed
Lst Cyc
x(2)
 
 
bic_last_due
Last Due Date Billed
Lst Due
99/99/99
 
 
bic_lst_date
Date Last Billed
 
99/99/99
 
 
bic_periods
Periods In Billing Year
 
>>9
 
 
bic_user1
Ufld1
 
x(8)
 
 
bic_user2
Ufld2
 
x(8)
 
 
oid_bic_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
bic_index1
yes
bic_domain
yes
no
 
oid_bic_ctrl
yes
oid_bic_ctrl
yes
no
Bill
Bill
 
 
Field Name
Label
Col-Label
Format
Dec
 
Bill_ID
Record ID
 
-99999999999
 
 
BillClosingBalanceTC
TC Closing Balance
 
->>>,>>>,>>>,>>9.99
4
 
BillConfirmDate
Bill Confirm Date
 
99/99/9999
 
 
BillDate
Bill Date
 
99/99/9999
 
 
BillDueDate
Bill Due Date
 
99/99/9999
 
 
BillNumber
Bill Number
 
999999999
 
 
BillOpeningBalanceTC
TC Opening Balance
 
->>>,>>>,>>>,>>9.99
4
 
BillPaymentAmtTC
TC Payment Amount
 
->>>,>>>,>>>,>>9.99
4
 
BillSalesAmtTC
TC Sales Amount
 
->>>,>>>,>>>,>>9.99
4
 
BillStatus
Status
 
x(20)
 
 
BillTaxAmtTC
TC Tax Amount
 
->>>,>>>,>>>,>>9.99
4
 
BillYear
Bill Year
 
9999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
Currency_ID
Link to Currency
 
-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
Link to Debtor
 
-99999999999
 
 
DInvoiceMovement_ID
Link to highest DInvoiceMovement
 
-99999999999
 
 
Employee_ID
Link to Employee
 
-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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CurrIdx
no
Currency_ID
yes
no
 
CyDebCurDateIdx
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
Currency_ID
yes
no
 
 
 
BillDate
yes
no
 
CyIdx
no
Company_ID
yes
no
 
DebIdx
no
Debtor_ID
yes
no
 
DIMIdx
no
DInvoiceMovement_ID
yes
no
 
EmplIdx
no
Employee_ID
yes
no
 ∗
Prim
yes
Bill_ID
yes
no
 
StatIdx
no
BillStatus
yes
no
 
UniqIdx
yes
Company_ID
yes
no
 
 
 
BillYear
yes
no
 
 
 
BillNumber
yes
no
BillSchedule
BillSchedule
 
 
Field Name
Label
Col-Label
Format
Dec
 
BillSchedule_ID
Record ID
 
-99999999999
 
 
BillScheduleCode
Billing Schedule Code
 
x(20)
 
 
BillScheduleDayInWeek
Day In the Week
 
x(20)
 
 
BillScheduleDescription
Description
 
x(40)
 
 
BillScheduleDueDateCalType
Calculation Type
 
x(40)
 
 
BillScheduleIsActive
Active
 
yes/no
 
 
BillScheduleIsUpdInvByBill
Update Invoice DueDate
 
yes/no
 
 
BillScheduleIsWeek1InMnth
Week 1
 
yes/no
 
 
BillScheduleIsWeek2InMnth
Week 2
 
yes/no
 
 
BillScheduleIsWeek3InMnth
Week 3
 
yes/no
 
 
BillScheduleIsWeek4InMnth
Week 4
 
yes/no
 
 
BillScheduleMthBillDay1
Billing Day 1
 
>9
 
 
BillScheduleMthBillDay2
Billing Day 2
 
>9
 
 
BillScheduleMthBillDay3
Billing Day 3
 
>9
 
 
BillScheduleMthBillDay4
Billing Day 4
 
>9
 
 
BillScheduleMthDelay1
Months Delay 1
 
9
 
 
BillScheduleMthDelay2
Months Delay 2
 
9
 
 
BillScheduleMthDelay3
Months Delay 3
 
9
 
 
BillScheduleMthDelay4
Months Delay 4
 
9
 
 
BillScheduleMthDueDay1
Due Day 1
 
>9
 
 
BillScheduleMthDueDay2
Due Day 2
 
>9
 
 
BillScheduleMthDueDay3
Due Day 3
 
>9
 
 
BillScheduleMthDueDay4
Due Day 4
 
>9
 
 
BillSchedulePattern
Pattern
 
x(20)
 
 
BillScheduleSelectInvBasedOn
Select Invoice Based On
 
x(20)
 
 
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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ActiveIdx
no
BillScheduleIsActive
yes
no
 
CodeIdx
yes
BillScheduleCode
yes
no
 
PatDueIdx
no
BillSchedulePattern
yes
no
 
 
 
BillScheduleDueDateCalType
yes
no
 ∗
Prim
yes
BillSchedule_ID
yes
no
BLWIGroup
BLWI Group
 
 
Field Name
Label
Col-Label
Format
Dec
 
BLWIGroup_ID
Record ID
 
-99999999999
 
 
BLWIGroupCode
BLWI Group Code
BLWI Group
x(20)
 
 
BLWIGroupDescription
Description
 
x(40)
 
 
BLWIGroupIsActive
Active
Act
yes/no
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Active
no
BLWIGroupIsActive
yes
no
 
Code
yes
BLWIGroupCode
yes
no
 ∗
Prim
yes
BLWIGroup_ID
yes
no
 
ViewIndex
no
BLWIGroupIsActive
yes
no
 
 
 
BLWIGroupCode
yes
no