This appendix lists the composite keys.
Composite Keys List
This section lists the composite keys for certain tables that the system converts during the base currency conversion. Use the composite key to create and run a query or batch program over the F0086 table.
|
Table Name |
Table Number |
Composite Key |
|
Taxes |
F0018 |
For F03B11 and F0411 table conversions: TDDOCO, TDDCTO, TDKCOO, TDSFXO For the F0911 table conversion: TDDOCO, TDDCTO, TDKCOO, TDSFXO, TDLNID |
|
Customer Ledger |
F03B11 |
RPDOC, RPDCT, RPKCO, RPSFX |
|
Accounts Payable Ledger |
F0411 |
RPDOC, RPDCT, RPKCO, RPSFX |
|
Accounts Payable - Matching Document |
F0413 |
RMDOCM, RMDCTM, RMPYE |
|
Accounts Payable Matching Document Detail |
F0414 |
RNDOC, RNDCT, RNDCTM, RNKCO, RNSFX |
|
Account Balances |
F0902 |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
|
Account Balances - 52 Period Accounting |
F0902B |
GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
|
Account Ledger |
F0911 |
GLDCT, GLDOC, GLKCO, GLDGJ, GLJELN, GLLT, GLEXTL |
|
Policy Edit Rules |
F09E108 |
POLICY, EXPTYPE, EFTJ, EXRPTTYP, LOCATN |
|
Credit Card Transaction Interface |
F09E150 |
CCTN |
|
Multi-Site Consolidation Transfer |
F1002 |
GQEDBT, GBEDUS, GQEDTN, GQSERK, GQMCU, GQOBJ, GQSUB, GQSBL, GQSBLT, GQCRCD, GQCRCX |
|
Location Tracking Table |
F1204 |
FMNUMB, FMEFTB, FMAL, FMNNBR |
|
Equipment License Master |
F1206 |
FHNUMB, FHADDS, FHLNUM |
|
Equipment Rates |
F1301 |
FGRTTB, FGRTGR, FGNUMB, FGEFTB, FGERC |
|
Rental Rules |
F1302 |
FKCO, FKMCU |
|
Equipment Location Billing |
F1304 |
FNTRNN, FNNNBR, FNLOC |
|
Equipment Analysis Costs |
F1383 |
EQGP, EQSP, SEQ, NUMB, AID, SBL, SBLT, LT, SMTP |
|
Forecast Basis |
F1403 |
MCU, AID, RVNUM |
|
Forecast Results - Header |
F1404 |
MCU, AID, RVNUM |
|
Forecast Results - Detail |
F14041 |
AID, RVNUM, FY, CTRY |
|
Forecast Growth Patterns |
F1406 |
GRWPC |
|
Lease Master Header |
F1501B |
DOCO, LSVR |
|
Tenant E.P. Class Master |
F15012B |
DOCO, LSVR, BCI |
|
Share Factor Denominator Audit |
F150122A |
ICU, SFDN, ECMP, GLMD, MCUS, MCU, UNIT, MT, CENTYR, ARDEFID |
|
Sales Overage Master File |
F15013B |
DOCO, LSVR, YEOV |
|
Product Scales Master |
F15014B |
DOCO, LSVR, YEOV, BCI |
|
Min/Max Rents And Recoveries Master |
F15015B |
DOCO, LSVR |
|
Tenant Escalation Master |
F15016B |
DOCO, BCI |
|
Recurring Billings Master |
F1502B |
DOCO, LNID |
|
Estimated EP Recurring Billings |
F1502WB |
ICU, DOCO, GLC, MCU, UNIT, BCI, UNGR |
|
Management Fee Master |
F1505B |
DOCO, MCU, BCI |
|
Revenue Fee Generation History |
F1505HB |
ICU, BCI, PMFY, BPN, CTRY |
|
Unit Master |
F1507 |
MCU, UNIT |
|
Lease Billings Master |
F1511B |
GENT, ICU, DOC, SFX, KCO |
|
Lease Billings History |
F1511HB |
GENT, DOCO, BPN, YR, CTRY, SOBT |
|
FASB 13 Lease Control |
F1513B |
DOCO, MCU, UNIT, CTRY, YR, ICU |
|
Building E.P. Caps |
F15151 |
CAPID, MCU, SEQ |
|
Lease E.P. Caps |
F15152 |
DOCO, LSVR, BCI, SEQN |
|
Lease Cap History |
F15153 |
ICU, DOCO, LSVR, BCI, CAPID, CAPLVL, MCU, OBJ, SUB, SBL, SBLT |
|
Fees and Interest |
F1525B |
FETP, DOCO, AN8, MCU, GLC, LNID, AGSN |
|
E.P. Class Cap Expenses History |
F15303 |
ICU, CAPID, EPCL, MCU, OBJ, SUB, SBL, SBLT |
|
Expense Participation Class Adjustment |
F1531 |
EPCL, LNID |
|
Expense Participation Audit File |
F1532B |
DCT, DOC, DGJ, JELN, ICU, EPCL, AID, LT, SBL, CO |
|
Tenant Account Exclusions |
F1533B |
DOCO, LSVR, ADJL, ADJTY, EPCL, MCU, UNIT, AID, LVLT, BCI |
|
EP Billing Register |
F1538B |
DOCO, LSVR, ICU, EPCL, BCI |
|
Occupancy Gross Up Audit |
F1538B1 |
ICU, DOCO, LSVR, EPCL, BCI, AID, SBL |
|
Exclusion/Redistribution |
F1538B2 |
ICU, DOCO, LSVR, EPCL, AID, BCI, ELRD |
|
EP Billing Account Adjustments Audit |
F1539A |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
|
EP Billing Class Adjustments Audit File |
F1539C |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
|
EP Billing Account Exclusions Audit |
F1539E |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
|
EP Billing Adj Factor EP Class Audit |
F1539FC |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
|
EP Billing Adj Factor Lease Audit |
F1539FL |
ICU, DOCO, LSVR, EPCL, BCI, LNID |
|
Sales Report Control |
F1540B |
DOCO, MCU, UNIT, DBAN, STNR, AN8, PRDC, LIN, RPRD, YR, CTRY |
|
Tenant Weekly Sales |
F15410 |
DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
|
Tenant Sales History |
F1541B |
DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
|
Sales History Work File |
F1541BW |
DOCO, MCU, MCUS, UNIT, DBAN, STNR, ULI, PRDC, CTRY, YR |
|
Projected Sales |
F1542 |
MCUS, DOCO, MCU, UNIT, DBAN, ULI, PRDC, STNR, CTRY, YR |
|
Tenant Sales Analysis Reporting File |
F1543B |
SASC, CTRY, YR, RPRD, MCU, AN8, UNIT, DBAN, PRDC, MCUS, CO, DOCO, FLOR, ULI, ULI2, DS40 |
|
Escalation Billing Register |
F1548B |
DOCO, ICU, BCI |
|
Security Deposit Master |
F1565 |
DOCO, LNID |
|
Legal Clause Amounts |
F15703 |
DOCO, AN8, CLNO, SEQN |
|
Market/Potential/Renewal Rent Master |
F159071 |
MCU, UNIT, RNTY, SEQ |
|
AREF Building Constants |
F15L100 |
MCU, RVNB |
|
AREF Building Constants Models |
F15L1001 |
BMCI |
|
AREF Unit Master |
F15L101 |
MCU, UNIT, RVNB (Release 8.0) MCU, UNIT, RVNB, UKID (Release 8.10 and above) |
|
AREF Unit Assumptions Master Header |
F15L102 |
MCU, ASSD, RVNB |
|
AREF Growth Pattern File |
F15L105 |
MCU, GRPA, RVNB |
|
AREF Base Account Definition |
F15L108 |
MCU, AID, RVNB |
|
AREF Budget Results |
F15L109 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
|
AREF Account Status |
F15L110 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
|
AREF Account Status Detail |
F15L111 |
MCU, RVNB, AID, CTRY, FY, SBL, SBLT, LNID |
|
AREF Unit Assumptions Master Detail |
F15L112 |
MCU, ASSD, RVNB, LNID |
|
AREF Sales Overage Detail |
F15L113 |
MCU, RVNB, SOID, SOSQ |
|
AREF E.P. Rules Detail |
F15L114 |
MCU, EPRD, RVNB, SEQ |
|
AREF Base Account Definition Detail |
F15L118 |
MCU, AID, RVNB, LNID |
|
AREF Projected Sales |
F15L301 |
DOCO, MCU, UNIT, RVNB, DBAN, PRDC, CTRY, YR |
|
AREF Prior Gross Billings |
F15L302 |
CTID, MCU, RVNB, DOCO, UNIT, LNID |
|
Case Master |
F1755 |
STAW, DOCO, UPMJ, UPMT |
|
Expense Report Header |
F20111 |
EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT |
|
Expense Report Detail |
F20112 |
EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT, LIN, RECTYPE, LNID |
|
Work Center Rates File |
F30008 |
IWMCU, IWLEDG |
|
Bill of Materials Changes File |
F3011 |
IZMMCU, IZKIT, IZTBM, IZITM |
|
DFM Bill of Material Master |
FF30L002 |
FSCID, DFKIT, DFMCU, DFTBM, BQTY, CPNB, SBNT, COBY |
|
Purge - Shop Floor Parts List |
F3111S |
WMCMCU, WMCPIT, WMCOBY, WMDOCO, WMOPSQ |
|
Outbound Work Order Parts List |
F3111Z1 |
SZCMCU, SZCPIT, SZCOBY, SZDOCO, SZOPSQ |
|
Work Order Time Transactions |
F31122 |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
|
Work Order Time Transactions Unedited Transaction Table |
F31122Z1 |
SZYST, SZAN8, SZDGL, SZDOCO, SZOPSQ, SZTYR |
|
Purge Work Order Time Transactions |
F31122S |
WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
|
Lean Transaction Parts List |
FF31111 |
UKID |
|
Lean Transaction Labor Detail |
FF31113 |
UKID |
|
Production Costs |
FF31200 |
PRODF31, TRSID, ITM, COST, PART |
|
Cost Groups Detail |
F31B211 |
WCG, LNID |
|
Blend Lot Costs |
F31B31C |
MCU, WLOTN, WCOST |
|
Blend Transactions |
F31B66 |
WOPID, LNID |
|
Rules Table Detail |
F3283 |
$2RRN |
|
Assembly Inclusion Rules |
F3293 |
KYKIT, KYMCU, KYATOT, KYATO#, KYATOS |
|
Needed for upgrade from Xe and below |
F32961 |
KLDOCO, KLDCTO, KLKCOO, KLLNID, KLITM, KLMCU, KLATLV |
|
Forecast File |
F3460 |
MFITM, MFMCU, MFDRQJ, MFTYPF, MFDCTO |
|
Batch Receiver File - Order Headings |
F4001Z |
SYDOCO, SYDCTO, SYKCOO |
|
Batch Receiver File - Order Headings |
F4011Z |
SZDOCO, SZDCTO, SZKCOO |
|
Price Adjustment Ledger File |
F4074 |
ALDOCO, ALDCTO, ALKCOO, ALLNID |
|
Price Variable Table |
F4075 |
VBVBT, VBEFTJ |
|
Grower Block |
F40G02 |
BLUID |
|
Grower Harvest |
F40G03 |
WVID |
|
Harvest Estimate Freeze Detail |
F40G032 |
FRZID, TYPEHB, WVID, UPLNMAT, LNID |
|
Crush and Purchase Report Details |
F40G150 |
WVID |
|
Item Cost File |
F4105 |
COITM, COMCU, COLOCN, COLOTN, COLEDG |
|
Average Cost Work file |
F41051 |
CHITM, CHMCU, CHLOCN, CHLOTN |
|
Item Ledger File |
F4111 |
ILDOC, ILDCT, ILKCO |
|
Item ASOF File |
F41112 |
INITM, INMCU, INLOCN, INGLPT, INCTRY, INFY |
|
Item History |
F4115 |
IHITM, IHMCU, IHCTRY, IHFY |
|
Container Deposit File |
F4118 |
CNCO, CNMCU, CNAN8, CNITM, CNRORN, CNRCTO |
|
Container Transaction File |
F41181 |
CMCO, CMMCU, CMAN8, CMITM, CMDOCO, CMDCTO |
|
Cycle Count Transaction File |
F4141 |
PJITM, PJMCU, PJLOCN, PJLOTN |
|
Item Cost Components |
F41291 |
IGPRP5, IGITM, IGMCU, IGLVLA, IGEFFT |
|
Sales Order Header File |
F4201 |
SHDOCO, SHDCTO, SHKCOO, SHSFXO |
|
Price by Item |
F4207 |
PMPCTY, PMMCAT, PMCLV, PMCXPJ |
|
Sales Order Detail File |
F4211 |
SDDOCO, SDDCTO, SDKCOO, SDLNID |
|
S.O. Detail Ledger File |
F42199 |
SLDOCO, SLDCTO, SLKCOO, SLLNID |
|
Commission Constants File |
F42004 |
CMAN8, CMDCTO, CMCCTY, CMCXPJ |
|
Sales Commission File` |
F42005 |
SCDOCO, SCDCTO, SCKCOO, SCLNID |
|
Order Hold Constants |
F42008 |
HCMCU, HCHCOD |
|
Sales Summary History File |
F4229 |
SSAN8, SSMCU, SSDCTO, SSITM, SSLNTY, SSSRP1, SSSRP2, SSSRP3, SSSEP4, SSSPR5, SSSSFY |
|
Purchase Order Header |
F4301 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Supplier/Item Relationships |
F43090 |
PCAN8, PCMCU, PCITM |
|
P.O. Detail Ledger File - Flexible Version |
F43199 |
OLDOCO, OLDCTO, OLKCOO, OLSFXO, OLLNID, OLNLIN, OLCORD, OLUPMJ, OLTDAY |
|
Purchase Order Detail |
F4311 |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Purchase Order Detail File |
F4311T |
PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
|
Purchase Order Receiver File |
F43121 |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
|
Purchase Order Receiver Tag File |
F43121T |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
|
Purchase Order Receiver Multiple Account |
F43126 |
P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
|
Purchase Order Receiver Multiple Account Tag File |
F43126T |
P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
|
Purchase Order Receiver Tag Table |
F43121TB |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, P4DOC |
|
Purchase Order Receiver Non-Billable |
F43127 |
PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, PRDLIND, PRNBACTY, PRDOC |
|
Purchase Order Multiple Account File |
F4316 |
DOCO, DCTO, KCOO, SFXO, LNID, AID, SBLT, SBL, DGL |
|
Purchase Order Multiple Account Tag File |
F4316T |
DOCO, DCTO, KCOO, SFXO, LNID, DLNID |
|
Purchase Order Detail Non-Billable |
F4317 |
DOCO, DCTO, KCOO, SFXO, LNID, NBACTY, DLNID, AID |
|
Purchasing Tolerance Rules |
F4322 |
PZFNTY, PZITM, PZPRP1, PZCO |
|
Multiple Requisition File |
F4332 |
P2DOCO, P2DCTO, P2KCOO, P2LNID, P2OORN, P2OCTO, P2OKCO, P2OGNO |
|
Purchase Rebate History |
F4343 |
RHAN8, RHAGSQ, RHDCTO, RHDOCO, RHKCOO, RHLNID |
|
Contract Header |
F43C01 |
CNTRTID |
|
Contract Block |
F43C10 |
CNTRTID, BLUID |
|
Contract Detail |
F43C11 |
CNTRTID, CNTRTDID |
|
Assessment Donations |
F43C30 |
ADADUKID |
|
Requisition Order Header |
F43E01 |
DOCO, DCTO, KCOO |
|
Requisition Detail |
F43E11 |
DOCO, DCTO, KCOO, SFXO, LNID |
|
Requisition Multiple Account File |
F43E16 |
DOCO, DCTO, KCOO, SFXO, DLNID |
|
Shopping Cart Detail |
F43E20 |
USER, LNID |
|
Event Header |
F43Q10 |
EVNU, DCTO, KCOO |
|
Event Detail |
F43Q11 |
EVNU, DCTO, KCOO, EVLN |
|
Event Header Bid Questions |
F43Q20 |
EVNU, DCTO, KCOO, BIDQN |
|
Event Detail Bid Questions |
F43Q21 |
EVNU, DCTO, KCOO, EVLN, BIDQN |
|
F43Q40 |
F43Q40 |
EVNU, DCTO, KCOO, BIDNUM, AN8 |
|
Response Header Question |
F43Q401 |
EVNU, DCTO, KCOO, BIDNUM, BIDQN, AN8 |
|
Response Line |
F43Q41 |
EVNU, DCTO, KCOO,EVLN,BIDNUM, AN8 |
|
Response Detail Question |
F43Q411 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8 |
|
Response Detail Question Price Break |
F43Q412 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, TRNB |
|
Response Detail Question Price Components |
F43Q413 |
EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, PCPTN |
|
Analyze Event Detail |
F43Q51 |
EVNU, DCTO, KCOO,EVLN, AN8, BIDNUM, AWARDNUM |
|
Bid Questions |
F43Q60 |
BIDCODE, CMDCDE, ITM |
|
Community Phase Master |
F44H101 |
HBMCUS,CPHASE |
|
Lot Master |
F44H201 |
HBMCUS,HBLOT |
|
Plan Master |
F44H301 |
HBMCUS, HBPLAN, CPHASE, HBELEV |
|
Option Master |
F44H401 |
HBAREA, HBMCUS, CPHASE, HBPLAN, HBELEV, OPTION |
|
Item Master HomeBuilder Extension |
F44H4101 |
ITM, HBAREA |
|
Sales Master Table |
F44H501 |
HBMCUS, HBLOT, CSSEQ |
|
Option Selections |
F44H511 |
HBMCUS, HBLOT, OPKID, OPTION |
|
Closing Worksheet Entries |
F44H591 |
HBMCUS, HBLOT, CLSRT, OPTION |
|
Material Item Pricing |
F44H603 |
HBAREA, ITM, AN8, HBMCUS, CPHASE, EFFF |
|
Bid Details |
F44H611 |
KCOO, DOCO, DCTO, SFXO, LNID |
|
Lot Start Workfile |
F44H711 |
MCU, OBJ, SUB, OPTION, AN8, ITM, SEQ |
|
After Start Purchasing |
F44H711P |
DOCO, DCT, KCOO, SFXO, LNID |
|
Extended Homebuilder Data |
F44H0929 |
HBAREA, HBMCUS, CPHASE, HBLOT, CSSEQ, HBPLAN, HBELEV, OPTION, SDTYP, SDKY, SDLIN |
|
EDI Purchase Order Header - Inbound |
F47011 |
SYEDOC, SYEDCT, SYEKCO |
|
EDI Purchase Order Detail - Inbound |
F47012 |
SZEDOC, SZEDCT, SZEKCO |
|
EDI Request for Quote Header - Inbound |
F47091 |
SYEDOC, SYEDCT, SYEKCO |
|
EDI Request for Quote Detail - Inbound |
F47092 |
SZEDOC, SZEDCT, SZEKCO |
|
EDI Product Activity Data Detail - Inbound |
F47122 |
MJEKCO, MJDOC, MJDCT |
|
EDI Product Activity Data Detail - Outbound |
F47127 |
MJEKCO, MJDOC, MJDCT |
|
EDI Purchase Order Change Header - Inbound |
F47131 |
EDOC, EDCT, EKCO, EDLN |
|
EDI Purchase Order Change Detail - Inbound |
F47132 |
EDOC, EDCT, EKCO, EDLN |
|
EDI P.O. Acknowledgement. Header - Outbound |
F47026 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Acknowledgement. Detail - Outbound |
F47027 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Shipping Notice Detail - Outbound |
F47037 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Header (Sales) - Outbound |
F47046 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Invoice Detail (Sales) - Outbound |
F47047 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Response to RFQ Header - Outbound |
F47106 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Response to RFQ Detail - Outbound |
F47107 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Purchase Order Header - Outbound |
F47016 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Purchase Order Additional Header - Outbound |
F470161 |
S3EDOC, S3EDCT, S3EKCO, S3EDLN |
|
EDI Purchase Order Additional Detail - Outbound |
F47017 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Purchase Order Additional Detail - Outbound |
F470171 |
S4EDOC, S4EDCT, S4EKCO, S4EDLN |
|
EDI P.O. Acknowledgment Header - Inbound |
F47021 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Acknowledgment Detail - Inbound |
F47022 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Header - Inbound |
F47041 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Invoice Detail - Inbound |
F47042 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Invoice Summary - Inbound |
F47044 |
SWEDOC, SWEDCT, SWEKCO, SWEDLN |
|
EDI Planning Schedule Detail - Inbound |
F47062 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
|
EDI Planning Schedule Detail - Outbound |
F47067 |
MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
|
EDI Receiving Advice Header - Inbound |
F47071 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Receiving Advice Detail - Inbound |
F47072 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Receiving Advice Header - Outbound |
F47076 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Receiving Advice Detail - Outbound |
F47077 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Request for Quote Header - Outbound |
F47096 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI Request for Quote Detail - Outbound |
F47097 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Purchase Order Change Header - Outbound |
F47136 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgment Header - Inbound |
F47141 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgment Detail - Inbound |
F47142 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI P.O. Change Acknowledgement Header - Outbound |
F47146 |
SYEDOC, SYEDCT, SYEKCO, SYEDLN |
|
EDI P.O. Change Acknowledgement Detail - Outbound |
F47147 |
SZEDOC, SZEDCT, SZEKCO, SZEDLN |
|
EDI Tolerance Rules |
F4722 |
PZEDST, PZAN8, PZEDSP, PZCO |
|
Work Order Master File |
F4801 |
WADCTO, WATYPS, WASRST, WADPL, WAAN8, WADOCO |
|
Billing Detail Workfile |
F4812 |
BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
|
Billing Workfile History |
F4812H |
BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
|
Invoice Summary Work File |
F4822 |
W4DOCZ, W4DCTI, W4KCOI, W4SFX |
|
Billing Rate / Mark up Table |
F48096 |
UKID |
|
Voucher Summary |
F4823 |
DOCZ, DCTI, KCOI, SFX |
|
Component Table Detail |
F4861 |
CTBL, CRCD, EFTB, UKID |
|
Burden Rates |
F48S85 |
SEGMID, EFTB, CRCD, BUCA, BURT, POOLID |
|
G/L Link |
F48S912 |
AID, BCI, DGL, PRSQ, SBSQ, SCSQ, CCOD, DCT, LT, UKID |
|
Sales Order Detail File - Tag File |
F49211 |
UDDOCO, UDDCTO, UDKCOO, UDLNID |
|
Load In-Transit Confirmed Quantities |
F49633 |
LDNM, VMCU, DLNO, SHPN |
|
Load In-Transit Confirmed Quantities Detail |
F49634 |
SHPN, DOCO, DCTO, KCOO, LNID |
|
Contract Billing Line Detail |
F5202 |
DOCO, DCTO, KCOO, COCH, LNID |
|
Contract Revenue Summary |
F5280 |
DOCO, DCTO, KCOO, COCH, LNID, CTRY, FY, PN |
|
Government Contract Modification |
F52G01M |
DOCO, DCTO, KCOO |
|
ACRN Details |
F52G05 |
DOCO, DCTO, KCOO |
|
ACRN History |
F52G05H |
DOCO, DCTO, KCOO, DOCZ, DCTI, KCOI, GACRN |
|
Government Contract Limit Summary |
F52G200 |
DOCO, DCTO, KCOO, PRTPG |
|
Actual Rate Calculation |
F52G60 |
REFID, SEGMID, SEQ, POOLID, BOBS, TRRN |
|
Suspended IVA Generation - Receipt/Rebate Control - Italy |
F743B14I |
TIDOC, TIDCT, TIKCO, TISFX, TIDOCM, TIDCTM |
|
IM Withholdings Setup |
F76V4025 |
WSCO, WSV76MUNW, WSV76MIIM, WSEFTJ |
|
VAT Withholdings Setup |
F76V4030 |
VWCO, VWV76VATW, VWEFTJ |
|
Withholding Historical File |
F76V4581 |
HRKCO, HRDCT, HRDOC, HRSFX, HRSFXE, HRCO |
|
Withholdings I.S.L.R. Fee 2 |
F76V4583 |
TDCO, TDAN8, TDAC07, TDFY, TDPN, TDDCT, TDDOC, TDIRQ |
|
Competitor Table |
F90CA060 |
CMAN8 |
|
Opportunity Table |
F90CB020 |
OPPID |
|
Opportunity Item Table |
F90CB02I |
OPPID, LNID |
|
Cost Table |
F90CB02M |
COSTID |
|
Forecast |
F90CB060 |
FCID |
|
Opportunity For Forecast |
F90CB06B |
FCID, OPPID |
|
Opportunity Item For Forecast |
F90CB06C |
OPPID, SEQNU, FCID |