APDISTRIB – Invoice Distribution

System
Accounts Payable (AP)
Prefix
APD
Primary key
API-OBJ-ID, DIST-SEQ-NBR
Fields
74
Updated by
72 programs
Referenced by
19 programs

APDISTRIB is the Invoice Distribution table in Lawson Accounts Payable (prefix APD). It is indexed by API-OBJ-ID, DIST-SEQ-NBR (APDSET1); alternate indexes: APDSET10, APDSET11, APDSET12, APDSET13, APDSET2, APDSET3, APDSET4, APDSET5 and 4 more. It is related 1:1 to ACTRANS, APCOMPANY, GLSYSTEM, APDSTBOD, APINVOICE, APPROCLEV, APUAVAL, APVENMAST and 7 more and 1:M to APDISTPAY, APDISTRIB, APVENDIV, PDCHRGDIST and SLTRANS. It is updated by AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 and 64 more and referenced by AP00.4, AP136, AP212, AP220, AP232, AP233, AP271, AP272 and 11 more. The table has 74 fields, 13 indexes and 23 documented relations.

About APDISTRIB

The Invoice Distribution Header file contains invoice distribution records. The presence of a tax code identifies the record as a tax distribution. Distribution records that have an asset number or asset template assigned will also have an associated record in the Asset Detail file.

Fields (74)

Column = COBOL field name without the APD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#APD-COMPANY SET11 SET12 SET13 SET2 SET8 SET9
COMPANY		Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-API-OBJ-ID PK
API_OBJ_ID		Numeric 12A unique identifier assigned to this file record.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +40 more
#APD-VENDOR SET13 SET7 SET9
VENDOR		Alpha 9 (Right Justified)The vendor number. Must be a valid record in the Vendor file.AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
#APD-INVOICE SET13 SET9
INVOICE		Alpha 22The invoice number. Represents a unique identifier for the invoice. Must be a valid record in the Accounts Payable Invoice file.AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
#APD-SUFFIX SET13 SET9
SUFFIX		Numeric 3The invoice suffix number. Represents the occurrence value of the invoice. The suffix is assigned by the system to recurring invoices, employee advances, and prepayment credit memos.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +36 more
#APD-CANCEL-SEQ SET13 SET9
CANCEL_SEQ		Numeric 4The sequence number assigned upon the cancellation of a distributed invoice. The first sequence assigned is 9999.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
#APD-ORIG-DIST-SEQ SET10
ORIG_DIST_SEQ		Numeric 6A unique sequence number.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
#APD-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number assigned to the distribution record.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +44 more
#APD-DIST-TYPE
DIST_TYPE		Alpha 1The distribution type. Valid values are: used for distributions that originate in the Accounts Payable system.)
  • D Distribution.
  • I Intercompany Distribution. (Not
  • G Gain/Loss Distribution.
  • R Tax/Reversal Distribution.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-PROC-LEVEL SET13 SET2
PROC_LEVEL		Alpha 5The process level associated with the distribution. Must be a valid record in the Accounts Payable Process Level file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +38 more
#APD-POST-OPTION
POST_OPTION		Alpha 1The general ledger posting option associated with the distribution record. Valid values are:
  • D Detail.
  • S Summary.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +36 more
#APD-INVOICE-TYPE
INVOICE_TYPE		Alpha 1The type of invoice associated with the distribution. Valid values are:
  • Blank Invoice.
  • C Credit Memo.
  • D Debit Memo.
  • P Prepayment.
  • Y Prepayment Credit Memo.
  • A Employee Advance.
  • M Employee Advance Credit Memo.
  • E Employee Expense.
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +36 more
#APD-REC-STATUS SET2
REC_STATUS		Numeric 1The distribution record status. Valid values are:
  • 0 Unreleased.
  • 1 Unposted (released).
  • 9 Posted by AP175.
  • 5 Pending
  • 6 Approved
  • 7 Rejected
AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +45 more
#APD-INV-CURRENCY
INV_CURRENCY		Alpha 5The currency of the invoice. Must be a valid record in the Currency Code file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-TAX-RATE
TAX_RATE		Percent 7.5 (Percent)The tax rate applied to the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +39 more
#APD-CURR-RATE
CURR_RATE		Signed 14.7The currency exchange rate applied to the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +43 more
#APD-ORIG-BASE-AMT
ORIG_BASE_AMT		Signed 18.2The amount of the distribution in company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +42 more
#APD-BASE-ND
BASE_ND		Numeric 1The number of decimals positions defined for the company base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-ORIG-TRAN-AMT
ORIG_TRAN_AMT		Signed 18.2The amount of the distribution in the currency of the invoice.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
#APD-TRAN-ND
TRAN_ND		Numeric 1The number of decimals defined for the invoice currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2The amount of the distribution in the distribution company's base currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +43 more
#APD-TO-BASE-ND
TO_BASE_ND		Numeric 1The number of decimal positions defined for the distribution company's currency.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2The taxable amount of the distribution.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
#APD-UNT-AMOUNT
UNT_AMOUNT		Signed 18.2The total unit amount allocated to the expense distribution.AP125, AP126, AP180, AP181, AP190, AP191, AP20.1, AP20.2 +33 more
#APD-DIST-COMPANY SET3 SET4
DIST_COMPANY		Numeric 4The distribution company assigned to the distribution. Must be a valid record in the General Ledger Company file and a valid relationship record must exist in the Intercompany Relationship file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-DIS-ACCT-UNIT SET13 SET2 SET4
DIS_ACCT_UNIT		Alpha 15The general ledger distribution accounting unit. Must be a valid record in the General Ledger Names file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
#APD-DIS-ACCOUNT SET13 SET2 SET4
DIS_ACCOUNT		Numeric 6The general ledger distribution account number. Must be a valid record in the General Ledger Account Master file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
#APD-DIS-SUB-ACCT SET13 SET2 SET4
DIS_SUB_ACCT		Numeric 4The general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
#APD-DISTRIB-DATE SET13 SET2 SET3 SET4
DISTRIB_DATE		Numeric 8 (yyyymmdd)The date used for posting the distribution to the general ledger.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP193 +41 more
#APD-TAX-INDICATOR
TAX_INDICATOR		Numeric 10
  • 1 Exempt
  • 2 Taxable
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +33 more
#APD-TAX-SEQ-NBR SET10
TAX_SEQ_NBR		Numeric 4—AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +23 more
#APD-TAX-CODE
TAX_CODE		Alpha 10The tax code assigned to the distribution. Represents tax information. If present, identifies the distribution as a tax distribution. Must be a valid tax code in Tax.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
#APD-TAX-TYPE
TAX_TYPE		Alpha 1Indicates the type of tax defined for the Tax Code. Valid values are: represents an increase to the invoice amount. the invoice amount.
  • I Invoiced. Default value. The tax
  • A Accrued. The tax does not increase
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +39 more
#APD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The distribution description.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +37 more
#APD-DST-REFERENCE
DST_REFERENCE		Alpha 10The distribution reference.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +34 more
#APD-ACTIVITY SET3
ACTIVITY		Alpha 15The activity assigned to the distribution, if applicable. Used to group expense distribution amounts to track costs for projects, jobs, construction, and so on, without having to define additional general ledger account numbers. Must be a valid activity in Project Accounting.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +42 more
#APD-ACCT-CATEGORY SET3
ACCT_CATEGORY		Alpha 5The account category assigned to the distribution, if applicable. Used to group distributions under an activity. Must be a valid account category for the activity in Project Accounting.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +39 more
#APD-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +23 more
#APD-ACCR-CODE
ACCR_CODE		Alpha 4The invoice accrual code associated with the distribution. Represents a general ledger accrual account. Must be a valid record in the Invoice Accrual Code file.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +43 more
#APD-PO-NUMBER SET8
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
#APD-PO-RELEASE SET8
PO_RELEASE		Numeric 4The purchase order release number associated with the distribution. Used to identify a purchase order release (created from a blanket or standing order).AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
#APD-PO-CODE SET8
PO_CODE		Alpha 4Purchase order number code. Used to keep purchase orders unique. Can also be used for reporting purposes.AP125, AP126, AP170, AP180, AP181, AP190, AP20.1, AP20.2 +27 more
#APD-PO-LINE-NBR SET8
PO_LINE_NBR		Numeric 6The purchase order line number associated with the distribution.AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +28 more
#APD-PO-AOC-CODE SET8
PO_AOC_CODE		Alpha 2Indicates whether this distribution record represents an add-on cost for a purchase order. Valid values are:
  • Y Yes.
  • N No.
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
#APD-GLT-OBJ-ID SET5
GLT_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +38 more
#APD-ATN-OBJ-ID SET9
ATN_OBJ_ID		Numeric 12A subsystem activity interface identification number. Used for Drill Around purposes.AP125, AP126, AP170, AP175, AP180, AP181, AP190, AP191 +38 more
#APD-ASSET-FLAG
ASSET_FLAG		Alpha 1Indicates whether an asset or asset repair record exists for the distribution. Valid values are: for the distribution.
  • A Asset.
  • R Repair Asset.
  • Blank No asset information is defined
  • Y Asset or Repair
AP125, AP126, AP170, AP180, AP181, AP190, AP191, AP20.1 +29 more
#APD-DIST-CODE
DIST_CODE		Alpha 9The distribution code assigned to the distribution. Used to split an expense distribution into multiple distribution lines. Must be a valid record in the Distribution Code Header file.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +25 more
#APD-TAX-POINT
TAX_POINT		Alpha 1Indicates when the tax amount is calculated for the invoice distribution, if applicable. Valid values are:
  • I Invoice.
  • P Payment.
  • G GL Post Date
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +32 more
#APD-VAT-REVERSE-FL
VAT_REVERSE_FL		Alpha 1Used in AP190 (Invoice Reinstatement) to create reversing tax due general ledger records. This field is No if reversing tax transactions have not been sent to the general ledger. When the transactions are sent to the general ledger, this field changes to Yes. Valid values are:
  • N No.
  • Y Yes.
AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +24 more
#APD-DST-OBJ-ID SET6
DST_OBJ_ID		Numeric 12An object identifier to keep the record unique.AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +17 more
#APD-MA-CREATE-FL
MA_CREATE_FL		Alpha 1Indicates the distribution was generated during matching, as opposed to entered manually during invoicing. Also used during the match reversal process to determine whether the distribution should be deleted (match distribution) or left untouched (miscellaneous distribution).AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +25 more
#APD-TAX-USAGE-CD
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP125, AP126, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3 +27 more
#APD-TRAN-DIST-FLAG
TRAN_DIST_FLAG		Alpha 1—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +9 more
#APD-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1—AP175, AP177
#APD-AC-UPD-STATUS
AC_UPD_STATUS		Numeric 1AC provides status that the activity reflects "cash basis" billing. Status change will reflect AP invoice for distibution has been paid and message of payment has been sent to AC.
  • 0 No payment information impact
  • 1 Requires payment information
  • 9 AP invoice paid. AC updated.
AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#APD-AC-UPD-DATE
AC_UPD_DATE		Numeric 8 (yyyymmdd)Last Ac distribtion record status change date.AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#APD-AC-UPD-TIME
AC_UPD_TIME		Numeric 6 (hhmmss)Last AC distribution record change time.AP125, AP126, AP175, AP178, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#APD-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +19 more
#APD-DISTRIB-ADJ
DISTRIB_ADJ		Numeric 1Identifies distribution as one that was created from AP30.2 Distribution Adjustments. If created in AP30.2 form value equal to '1'. Used to determine source code to send to GLTRANS and ACTRANS. 0
  • 1 Distribution Adjustment
AP30.2
#APD-DIST-STATUS
DIST_STATUS		DerivedIndicates whether the distribution is posted or unposted.—
#APD-TAX-FLAG
TAX_FLAG		Alpha 1—TX101
#APD-ICN-CODE
ICN_CODE		Alpha 8—AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
#APD-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
#APD-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4This field contains the desired quantity.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
#APD-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the type of inventory on this line.
  • G Goods
  • S Service
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +13 more
#APD-STATEMENT SET12
STATEMENT		Alpha 22Used to identify the invoice.API1.1, PD20.1, PD20.2, PD20.3
#APD-TXN-NBR SET12
TXN_NBR		Alpha 22—API1.1, PD20.1, PD20.2, PD20.3
#APD-RETAINAGE
RETAINAGE		Numeric 1—
  • 0 No
  • 1 Yes
AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +19 more
#APD-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15—AP125, AP126, AP170, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +20 more
#APD-CREATED-BY
CREATED_BY		Alpha 10—AP115, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +38 more
#APD-LAST-UPDT-DATE SET13
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)
#APD-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)
#APD-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP115, AP125, AP126, AP170, AP175, AP177, AP178, AP180 +52 more (list truncated in source)

Indexes (13)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
APDSET1
  1. API-OBJ-ID
  2. DIST-SEQ-NBR
PrimaryAP115, AP125, AP126, AP136, AP170, AP175, AP178, AP180 +22 more (list truncated in source)
APDSET10
  1. API-OBJ-ID
  2. ORIG-DIST-SEQ
  3. TAX-SEQ-NBR
KeyChange, SubsetWhere (ORIG-DIST-SEQ != Zeroes) And (TAX-SEQ-NBR != Zeroes)AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +15 more
APDSET11
  1. COMPANY
  2. API-OBJ-ID
  3. DIST-SEQ-NBR
SubsetWhere (PULL-FOR-FR-FL = "Y")AP177
APDSET12
  1. COMPANY
  2. STATEMENT
  3. TXN-NBR
  4. API-OBJ-ID
  5. DIST-SEQ-NBR
SubsetWhere (PO-NUMBER = Spaces) And (STATEMENT != Spaces)—
APDSET13
  1. COMPANY
  2. DISTRIB-DATE
  3. LAST-UPDT-DATE
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. CANCEL-SEQ
  8. PROC-LEVEL
  9. DIS-ACCT-UNIT
  10. DIS-ACCOUNT
  11. DIS-SUB-ACCT
  12. API-OBJ-ID
  13. DIST-SEQ-NBR
KeyChange—
APDSET2
  1. COMPANY
  2. REC-STATUS
  3. PROC-LEVEL
  4. DIS-ACCT-UNIT
  5. DIS-ACCOUNT
  6. DIS-SUB-ACCT
  7. DISTRIB-DATE
  8. API-OBJ-ID
  9. DIST-SEQ-NBR
KeyChangeAP00.4, AP175, AP178, AP195, AP211, TX101
APDSET3
  1. DIST-COMPANY
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. DISTRIB-DATE
  5. API-OBJ-ID
  6. DIST-SEQ-NBR
KeyChangeAP95.2, AP95.3
APDSET4
  1. DIST-COMPANY
  2. DIS-ACCT-UNIT
  3. DIS-ACCOUNT
  4. DIS-SUB-ACCT
  5. DISTRIB-DATE
  6. API-OBJ-ID
  7. DIST-SEQ-NBR
KeyChangeAP237, AP275, AP95.2, AP95.3
APDSET5
  1. GLT-OBJ-ID
  2. API-OBJ-ID
  3. DIST-SEQ-NBR
KeyChange, SubsetWhere GLT-OBJ-ID != ZeroesMM280, MM80.1, MM80.2
APDSET6
  1. DST-OBJ-ID
KeyChange, SubsetWhere DST-OBJ-ID != Zeroes—
APDSET7
  1. VENDOR
  2. API-OBJ-ID
  3. DIST-SEQ-NBR
AP272, AP36.2, TX101
APDSET8
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. PO-LINE-NBR
  6. PO-AOC-CODE
  7. API-OBJ-ID
  8. DIST-SEQ-NBR
KeyChange, SubsetWhere PO-NUMBER != SpacesAP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1, AP23.1 +8 more
APDSET9
  1. ATN-OBJ-ID
  2. COMPANY
  3. VENDOR
  4. INVOICE
  5. SUFFIX
  6. CANCEL-SEQ
  7. DIST-SEQ-NBR
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACTRANSAPCOMPANYGLSYSTEMAPDSTBODAPINVOICEAPPROCLEVAPUAVALAPVENMASTAPASTDTLAPDSUSRFLDGLMASTERGLNAMESPDCHRGAPIPDCHRGDTL+1 more belowAPDISTPAYAPDISTRIBAPVENDIVPDCHRGDISTSLTRANSAPDISTRIB

One to one (18) — lookups and parents

RelationTableRulesConditionField map
ActransACTRANSNot Required
APD-ATN-OBJ-ID→-OBJ-ID (XXXXXXXXXX)
ApcompanyAPCOMPANYRequired
APD-COMPANY→CPY-COMPANY
ApdistcompanyGLSYSTEMRequired
APD-DIST-COMPANY→GLS-COMPANY
ApdstbodAPDSTBODNot Required, Delete Cascades
APD-API-OBJ-ID→YAY-API-OBJ-ID
APD-DIST-SEQ-NBR→YAY-DIST-SEQ-NBR
ApinvoiceAPINVOICERequired
APD-COMPANY→API-COMPANY
APD-VENDOR→API-VENDOR
APD-INVOICE→API-INVOICE
APD-SUFFIX→API-SUFFIX
APD-CANCEL-SEQ→API-CANCEL-SEQ
ApproclevAPPROCLEVRequired
APD-COMPANY→APR-COMPANY
APD-PROC-LEVEL→APR-PROC-LEVEL
ApuavalAPUAVALNot Required
"D"→UAV-SEG-TYPE
APD-API-OBJ-ID→UAV-API-OBJ-ID
APD-DIST-SEQ-NBR→UAV-DIST-SEQ-NBR
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
APD-VENDOR→VEN-VENDOR
AssetAPASTDTLNot Required
APD-API-OBJ-ID→APS-API-OBJ-ID
APD-DIST-SEQ-NBR→APS-DIST-SEQ-NBR
DistribprocAPPROCLEVRequired
APD-COMPANY→APR-COMPANY
APD-PROC-LEVEL→APR-PROC-LEVEL
DstusrfldAPDSUSRFLDNot Required
APD-API-OBJ-ID→DFL-API-OBJ-ID
APD-DIST-SEQ-NBR→DFL-DIST-SEQ-NBR
GlmasterGLMASTERRequired
APD-DIST-COMPANY→GLM-COMPANY
APD-DIS-ACCT-UNIT→GLM-ACCT-UNIT
APD-DIS-ACCOUNT→GLM-ACCOUNT
APD-DIS-SUB-ACCT→GLM-SUB-ACCOUNT
GlnamesGLNAMESRequired
APD-DIST-COMPANY→GLN-COMPANY
APD-DIS-ACCT-UNIT→GLN-ACCT-UNIT
Glsystem OrigGLSYSTEMRequired
APD-COMPANY→GLS-COMPANY
Glsystem ToGLSYSTEMRequired
APD-DIST-COMPANY→GLS-COMPANY
PdchrgapiPDCHRGAPINot Required
APD-API-OBJ-ID→PDO-API-OBJ-ID
APD-STATEMENT→PDO-STATEMENT
PdchrgdtlPDCHRGDTLNot RequiredValid When (APD-PO-NUMBER = Spaces) And (APD-STATEMENT != Spaces)
PDO-PCARD-PROGRAM→PXD-PCARD-PROGRAM
APD-STATEMENT→PXD-STATEMENT
APD-COMPANY→PXD-COMPANY
APD-TXN-NBR→PXD-TXN-NBR
PorebdistPOREBDISTRequired
APD-API-OBJ-ID→RDS-API-OBJ-ID
APD-DIST-SEQ-NBR→RDS-DIST-SEQ-NBR

One to many (5) — child tables

RelationTableRulesConditionField map
ApdistpayAPDISTPAY
APD-COMPANY→DTY-COMPANY
APD-VENDOR→DTY-VENDOR
APD-INVOICE→DTY-INVOICE
APD-SUFFIX→DTY-SUFFIX
APD-DIST-SEQ-NBR→DTY-DIST-SEQ-NBR
—→DTY-LINE-NBR
—→DTY-MAD-SEQ-NBR
—→DTY-PMT-SEQ-NBR
ApdistribAPDISTRIBDelete Cascades
APD-API-OBJ-ID→APD-API-OBJ-ID
APD-DIST-SEQ-NBR→APD-ORIG-DIST-SEQ
—→APD-TAX-SEQ-NBR
ApvendivAPVENDIV
CPY-VENDOR-GROUP→VDC-VENDOR-GROUP
APD-VENDOR→VDC-VENDOR
API-LOCATION→VDC-LOCATION-CODE
—→VDC-DIVERSE-CODE
—→VDC-DCERT-DATE
PdchrgdistPDCHRGDIST
PDO-PCARD-PROGRAM→PDS-PCARD-PROGRAM
APD-STATEMENT→PDS-STATEMENT
APD-COMPANY→PDS-COMPANY
APD-TXN-NBR→PDS-TXN-NBR
—→PDS-SEQ-NBR
SltransSLTRANS
APD-GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (72)

Referenced by (19)